Change from number to date

[ekayani]

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))

[armingrudd]

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.

[ekayani]

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