Automation email steps and Date Time fields

[Richard_Willia1]

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.

[joshsorenson]

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?

[Richard_Willia1]

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!