Date formatting issues in Knime

Hi All,
I have a column “Appointment Date” in my table. However the data is stored in a peculiar format i.e. 1st 9 days of the month is shown as dmmyyyy and rest of the days are shows as ddmmyyyy. The data type of this column is also numbers(integers).

How can I change the data type to date format (ddmmyyyy) for all the values?

hi @abishaymathewd,

that means, you have to add a leading “0” in case of dMMyyyy.
Before you have to transform the number to a string.
Then, a transformation to a date format should work using the ddMMyyyy pattern.

Check this workflow. Hope that helps, Tommy


thanks @tommy. the workflow worked brillantly :smiley: