how to create date format with day month year columns ?

Hi all,

I am new to knime, pls someone help me on this.

i have 3 columns i.e, Day Month Year.

Day Month Year
01 05 2016
29 12 2016

how can i get date format like dd-MM-YYYY out of these columns.

Thanks

Anusha

 

1 Like

Hi Anusha,

assuming that your individual columns are strings, you can combine them using the Column Combiner node (if not, please convert them to strings first with the Number to String node). Next, you can convert them to date format via the String to Date/Time node, see the attached example workflow.

Hope that helps!

Cheers,

Roland

Hi @RolandBurger,
Do you have something similar for bringing in the time field (e.g. a 24-hour hour field, or minutes with a single “5” instead of “05”?
Thanks!

Hi @supersharp,

You can try this with the attached example. It appends a 0 to single-digit hours/minutes, which then allows you to convert them.

Cheers,
Roland

timeCombine.knwf (26 KB)

2 Likes

Thanks @RolandBurger!