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.
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!