How to convert Date and Time of a Field to DD-MM-YYYY HH:MM:SS

[AJAY533633]

Hello !

Can one help me on this format below

I have column as 'PublishedTime' and the value as 'Jan 28, 2022 10:40 AM' 

However i would need it as  "DD-MM-YYYY HH:MM:SS" (In 24 Hours Format )

Kindly help on the same

Thanks in Advance!

Ajay533633

[Frank_Hartmann]

try this:

date(date#(PublishedTime,'MMM DD, YYYY hh:mm TT'),'DD-MM-YYYY hh:mm:ss') as PublishedTime_New

[BrunPierre]

Timestamp(Timestamp#(PublishedTime,'MMM DD, YYYY hh:mm TT'),'DD-MM-YYYY hh:mm:ss') as " 24HourPublishedTime"