Date format conversion

eromiyasimon — Wed, 07 Dec 2022 08:48:10 GMT

Hi Team,

Below is my input date format

"20221201T154906.030+0800"

I'm expecting the below format from the input

"dd/mm/yyyy HH:MM:SS"

date(date#('20221201T154906.030+0800','YYYY_DD_MM'),'dd/mm/yyyy HH:MM:SS')

Can someone advise what is format i need to define on the above date format query or kindly help with your own query.

Thank you very much in advance.

Regards,

Eromiya Manickam

Re: Date format conversion

BrunPierre — Wed, 07 Dec 2022 19:39:51 GMT

Timestamp(Left("20221201T154906.030+0800", 19), 'DD/MM/YYYY hh:mm:ss')