Skip to main content

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?

What do you want the value to be?


Here is one option.


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

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!!


Reply