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?
20191020 into 20/10/2019
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.
Hi @armingrudd, thank you so much. It works!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.