Datetime

[ChannaK]

i have date like below

2023-10-13 07:42:41 UTC

can we convert this in AM PM format?

[StarinieriG]

Hello,

try with 

TimeStamp(Timestamp#(PurgeChar(FIELD,'UTC'),'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss[.fff] TT')

[BrunPierre · Accepted solution]

Perhaps

Timestamp(Timestamp#(Replace(MyDateTime, 'UTC',''),'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss TT')