Formula for converting a timestamp to show 24 hour time
I have a date/time formula that outputs a value like this: 09-18-2021 04:00 PM I need to convert it to: 09-18-2021 16:00 This one is giving me a lot of trouble as there doesn't seem to be a b...
The problem with what you did there is if you use [my test for ToD] in a formula text field, it will return 4:00 PM instead of 16:00, even if you have that field set to format it to 24 hour clock.
Here, the field [DateTime] is just a date/time field.
[TimeOfDay] is a formula - timeofday field set to 24 hour clock, with the formula: toTimeofDay[DateTime].
The field [Calculated] is a formula text field with the formula: toText([TimeOfDay]).
You can see it ignore the format settings and flips back to 1:49 pm.
------------------------------ Jeff Peterson ------------------------------
Yeah like I said not a full solution but it might work depending how you need to use it. Does it do the same thing in actions, automations, or pipelines? That would be a question for the next person looking at this probably.
