How to change date format

[#1]

Hello

I have a table in which date is in the format YYYYMMDD.

How can I change it to the form DD/MM/YYYY

Warehouse_Order:

CREATED_DATE

as

Created_Date

,

resident (some table which gets data from an extractor from SAP)

Please help.

Arjun Jain

[alexandros17]

Try with

Load

...

date(myDate, 'DD/MM/YYYY') as newDate

....

let me know

[Gysbert_Wassenaar]

date(date#(Created_Date,'YYYYMMDD'),'DD/MM/YYYY') as Created_Date

[Peter_Cammaert · Accepted solution]

And if that doesn't produce the results you want, try

:

date(date#(CREATED_DATE, 'YYYYMMDD'),'DD/MM/YYYY') as Created_Date