Hey, do you know how can i get in a field, only the hour format Hour/minutes like 09:34, without the date ?? thank you
Get only the hour of last modified time
+2Hi Clement. Try this…
DATETIME_FORMAT(SET_TIMEZONE({Last Modified}, ‘America/New_York’), ‘h:mm a’)
Use your own timezone (it may be ‘Europe/Paris’) in the SET_TIMEZONE function. You can find the list here Supported timezones for SET_TIMEZONE – Airtable Support
Good luck!
Hi Clement. Try this…
DATETIME_FORMAT(SET_TIMEZONE({Last Modified}, ‘America/New_York’), ‘h:mm a’)
Use your own timezone (it may be ‘Europe/Paris’) in the SET_TIMEZONE function. You can find the list here Supported timezones for SET_TIMEZONE – Airtable Support
Good luck!
Thank !! This is exactly what I was looking for ! I just find the format of the Formula, really amazing :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.