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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .