topic Re: Date conversion in App Development

Date conversion

AJerbi — Fri, 02 Sep 2022 16:08:53 GMT

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 ?

Re: Date conversion

deepanshuSh — Fri, 02 Sep 2022 16:31:11 GMT

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

Re: Date conversion

sidhiq91 — Fri, 02 Sep 2022 16:48:48 GMT

@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;