Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Datetime_Format Not Working for Time

2509 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Friedlan2
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

5 Replies 5

You need to use lowercase m’s.

MY HERO!!!

Now it makes sense that I see it. It was putting in the month, but driving me nuts.

You’re welcome! This is your reference page:

John_M
5 - Automation Enthusiast
5 - Automation Enthusiast

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')
John_M
5 - Automation Enthusiast
5 - Automation Enthusiast

Nevermind - figured it out… Had to adjust for CDT vs GMT.