Hello,
I have two date fields: one set as a date type for content entry/management and the other one for specific time zone display purposes. This works great at in the table view:
However, when I want to display those same values (grid view) in an automation email, my formula for the formatted date renders nothing:
This is the formula I am using:
DATETIME_FORMAT(SET_TIMEZONE({Date}, 'America/Chicago'), 'M/D/YYYY h:mm')
Looks like this is a related issue: Automations not displaying formula references and date fields. But this does not appear to have a resolution.
Thanks for the help!
