Date format conversion

[eromiyasimon]

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

[BrunPierre · Accepted solution]

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