Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
@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;
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')
@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;