Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Yup. 🙂
Thanks David,