
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 12, 2022 05:26 AM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 12, 2022 05:36 AM
What do you want the value to be?
Here is one option.
VALUE(
DATETIME_FORMAT(SET_TIMEZONE({Submitted at}, ‘America/Chicago’),‘hmm’)
)
Reply

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 12, 2022 05:40 AM
That’s EXACTLY what I needed. Thanks!!
Reply
