Date conversion

[AJerbi]

Hello Community ,

I have these two date fileds formats that i want to convert to a DD/MM/YYYY format 

2022-05-19T20:45:49.611956+04:00

27-SEP-21 12.00.00.000000000 AM

Can you please help ?

[deepanshuSh]

For, first you can directly use this, or use left here as well to truncate the data. =date(Date,'DD/MM/YYYY') and for second use combination of left and date # combination =date(date#(left(Date1,9), 'DD-MMM-YY'),'DD/MM/YYYY')

[sidhiq91 · Accepted solution]

@AJerbi  Please see below codes that is used in the backend:

NoConcatenate
Temp:
Load date(left(Date,10),'DD/MM/YYYY') as Date
Inline [
Date
2022-05-19T20:45:49.611956+04:00
];

NoConcatenate
Temp1:
Load Date(date#(left(Date,9),'DD-MMM-YY'),'DD/MM/YYYY') as Date1
Inline [
Date
27-SEP-21 12.00.00.000000000 AM
];

Exit Script;