Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How to convert the 12hr format to 24hr format.
Hi,
First make sure your time format is set to below formats.
1.) 24hr to 12hr:
SET TimeFormat='hh:mm:ss[.fff]';
syntax: Timestamp('YourTimeField' ,'hh:mm:ss TT')
2.) 12hr to 24hr:
SET TimeFormat='hh:mm:ss TT';
syntax: Timestamp('YourTimeField' ,'hh:mm:ss')
Regards,
Phani
Thanks for your response. My Currenttimestamp is 'hh:mm:ss TT'. I have two datetime Field one it is showing in 24 hr format. Other it is showing in the 12 hr format which is coming as the output of ConvertToLocalTime.
Didin't understand why you were not able to convert to 24hr.
See attached if that help's....
if not throw a sample where you are not able to convert.
Regards,
Phani
Hi
Try something like (change to the correct field name):
Time(Time#(ConvertToLocalTime(TimeValueField), 'hh:mm:ss TT'),'hh:mm:ss');
Regards
Jonathan
Thanks for all your response.