Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 23, 2022 12:44 PM
I have a formula that is taking a Start Date Field with value 9/10/2022 2:30pm GMT
I am trying to get the time of the event in 24 hour format using DATETIME_FORMAT({Start Date},“HH:MM”)
The result is coming up 21 minutes short and giving me 14:09 vs. 14:30.
Makes no sense.
Jul 23, 2022 12:47 PM
You need to use lowercase m’s.
Jul 23, 2022 12:48 PM
MY HERO!!!
Now it makes sense that I see it. It was putting in the month, but driving me nuts.
Jul 23, 2022 12:49 PM
You’re welcome! This is your reference page:
Aug 04, 2022 09:51 AM
I have a similar issue, but mine is displaying a different hours altogether.
The timestamp in my “Submitted at” field I have is 8/3/2022 17:23 …
Should return 17, yes?
I’m getting 22.
Formula is as follows:
DATETIME_FORMAT({Submitted at},'H')
Aug 04, 2022 10:22 AM
Nevermind - figured it out… Had to adjust for CDT vs GMT.