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?
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!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.