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?
Here’s what I need, if someone would be so kind as to assist…
I have a Submitted at column which tags the date/time the record was created from a form entry.
I have a Completed column which tags the date/timestamp when the Completed box is checked, w...
I have a similar issue, but mine is displaying a different hours altogether.
The timestamp in my “Submitted at” field I have is 8/3/2022 17:23 …
Should return 17, yes?
I’m getting 22.
Formula is as follows:
DATETIME_FORMAT({Submitted at},'H')