Transform date format

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
image

This is the derived new date format
image

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

Hi,

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

Hope this helps
Andrej

3 Likes

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:

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.