Change from number to date

I currently work in a database that has date format yyyymmdd (without delimiter) and how if I want to convert into dd/mm/yyyy format in Knime?

example:

20191020 into 20/10/2019

in excel:
for example 20191020 in cell A2
to convert I used formula --> =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))

Hi @ekayani and welcome to the KNIME community forum,

The String to Date&Time node with “yyyyMMdd” date format can convert the numbers to date.

If the column type is integer then you can use the Number to String node first.

:blush:

5 Likes

Hi @armingrudd, thank you so much. It works!

1 Like

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