I need to extract the hours from a Date/Time field in the format: 12:00, 13:00, 14:00, 16:00.

Right now I'm using this function:

"Date/time field".format('hh:mm:ss a');

But the hours comes in the form of 4:00 PM. How can I change the format?

1 Answer 1


You'll want to change your formula to look like:

"Date/time field".format('kk:mm:ss'); 

See the Java Simple Date Time Format Page for more.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.