Apr 13, 2023 04:42 PM
Once again it appears airtable haven't realised that maybe it's useful if dates and times can actually be used in reporting - from what I can see when using a list record source in a send email automation step there is no way to get dates and times to display in the time zone specified in the table. Instead they will only ever show in UTC
This makes automations useless for anything involving date times.
I dispair.
Apr 13, 2023 07:42 PM
Have you tried setting the date/time field to default to a specific timezone? Or use a formula to set the timezone in a secondary field?
Apr 14, 2023 03:37 AM
You would think that would work but sadly not - the automation section seems to ignore time zones, and also won't display the result of calculated date-time fields (they just appear blank or garbled). Very frustrating!