Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Need Timestamp as Number

Topic Labels: Formulas
126 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have this formula to pull the time from a date/time column…

DATETIME_FORMAT(SET_TIMEZONE({Submitted at}, ‘America/Chicago’),‘h:mm’)

Is there a way to have AirTable recognize this as a number?

2 Replies 2

What do you want the value to be?

Here is one option.

VALUE(
DATETIME_FORMAT(SET_TIMEZONE({Submitted at}, ‘America/Chicago’),‘hmm’)
)

That’s EXACTLY what I needed. Thanks!!