Automated Emails with Records Ordered by Date of Each Event

[Praise_Hall]

Hello! 

I am hoping to send weekly staff wide emails detailing a list of upcoming programs and events at my Foundation. I set up the Automation and it works well. However, the dates are ordered by when a record was created and not based on the actual date of a program. I've seen others with this issue in the past and I tried ungrouping the data but nothing has worked. Is there a feasible workaround for this yet? 

It would also be great if when sending the date / time for an event it sent it in EST time instead of UTC. I have it formulated in the data layer to so that is recognizes an EST time zone but in the weekly email it still is presented as UTC. 

Please help! I have an example below with the out of order dates and UTC time zone. 

Thanks, 

Praise 

[TheTimeSavingCo · Accepted solution]

Hm, when I do a "Find Record" action based on a view where it's sorted by the date, the grid that gets created is sorted similarly:

As you can see, it's sorted by "Date" and not by the Created Time 
---

> It would also be great if when sending the date / time for an event it sent it in EST time instead of UTC. I have it formulated in the data layer to so that is recognizes an EST time zone but in the weekly email it still is presented as UTC. 

Ah for this, I'm afraid you'll need to create a new formula field to display it in the timezone / format you want:

Link to base

[Praise_Hall]

Thanks for this! Could you share the formula you used format the date with day of week included, it would be awesome to show the date that way. 

[TheTimeSavingCo · Accepted solution]

Yeap sure, here! 

DATETIME_FORMAT(
  Date,
  "LLLL"
)

[Praise_Hall]

Thank you so much!