Convert a timestamp from 12 hr to 24 hr in script

[RSvebeck]

Hi

I have a textfile containing timestamps with 12hr format.

I need to convert those timestamps into a 24 hr format, wich is my standard timeformat in the document.

But this does not work when writing in scipt:

Timestamp(Timestamp#(MyTimeStampFieldin12HrsFormat,'hh:mm:ss TT') ,'hh:mm:ss') as MyTimeStampFieldin24HrsFormat

Why?

Best Regards

Robert

[daveamz · Accepted solution]

Hello Robert,

     Time format for 12 horus is 'h:mm:ss' and you need the 'hh:mm:ss' format, so drop one h from Timestamp# function:

Timestamp(Timestamp#(MyTimeStampFieldin12HrsFormat,'h:mm:ss TT') ,'hh:mm:ss') as MyTimeStampFieldin24HrsFormat

Best regards,

David

[RSvebeck]

Yup. 🙂

Thanks David,