Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need Timestamp as Number

Topic Labels: Formulas
1056 2
cancel
Showing results for 
Search instead for 
Did you mean: 
John_M
5 - Automation Enthusiast
5 - Automation Enthusiast

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

That’s EXACTLY what I needed. Thanks!!