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?
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?
Best Answer
You'll want to change your formula to look like:
See the Java Simple Date Time Format Page for more.