Skip to main content
Solved

Records in "Find Records" Automation have incorrect timecode


Forum|alt.badge.img+4

Hello!

I'm using a daily "find records" automation to send out digest emails to my team. 

I display the records in a list or grid in the email, including their Start and End fields (the records are tasks).

In my base, I've formatted both the Start and End fields to display in the same timezone (EST) for all collaborators. 

However, in my automation, the timezone is displayed in UTC, and I don't see a way to edit it. 

Is there a way to ensure that the date/time in the "find records" automation matches what is in my base? 

Thank you in advance!

Best answer by TheTimeSavingCo

Hm, so it's able to find all the right records, but in the email it's displaying UTC, is that right?

In table:

In email:

  

 

If so, I think the only way to deal with this is to create a formula field with `DATETIME_FORMAT()` showing what you'd like, and then using said field in your Grid / List in your email I'm afraid

View original
Did this topic help you find an answer to your question?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+28

Hm, so it's able to find all the right records, but in the email it's displaying UTC, is that right?

In table:

In email:

  

 

If so, I think the only way to deal with this is to create a formula field with `DATETIME_FORMAT()` showing what you'd like, and then using said field in your Grid / List in your email I'm afraid


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • February 10, 2023
TheTimeSavingCo wrote:

Hm, so it's able to find all the right records, but in the email it's displaying UTC, is that right?

In table:

In email:

  

 

If so, I think the only way to deal with this is to create a formula field with `DATETIME_FORMAT()` showing what you'd like, and then using said field in your Grid / List in your email I'm afraid


Hey Adam,

Thanks for your reply. This worked - I appreciate your help!


Reply