Transform date format

[jacksonsin]

Hi all,

I would need help on the date format

The data table has 2 columns i.e, Month Year.

|Month|Year|
January (String) | Year (Integer)

I try to create a workflow to concatenate

This is the derived new date format

The string-to-date&time node doesn’t seem to work on the new date format

How do I proceed from here to convert date format into dd-mm-yyyy?
Or is there a better way to create the workflow to get the dd-mm-yyyy output?

Thanks
Jackson

[andrejz]

Hi,

In the “String to Date&Time” node set the Date format to dd-MMMM-yyyy

Hope this helps
Andrej

[ipazin]

Hi there @jacksonsin,

welcome to KNIME Community!

After String to Date&Time node you will have column type Local Date which has yyyy-mm-dd representation. Check this topic for more on this matter:

Date format changed to yyyy-mm-dd from dd-mm-yyyy when using "string to date/time" node?

When converting string to date format using string to Date/Time node,the format for date column changed to yyyy-mm-dd from dd-mm-yyyy.

Br,
Ivan