Skip to main content

 

Good day.  

I’m looking to add or rather hard code the time 6:00am as shown int the automation field below:
 

How might I go about doing this?  Currently it brings in the date, but it changes a bit.  For example it’s specified as 7/21/2025, however what it changes it to is 7/20/2025 5:00pm 

 

Here’s the automation:

Would there be some way to “tack” on the hard coded time 6am or would I have to create yet another field to do that?  

Eventually this will be used in a Workato Recipe, and they’re more buggy.

 

Thanks!

Heres’ before the automation runs above:

 

As you can see, it not only changed the day, but also set the time to 5pm.

Classic timezone issue, Airtable loves Greenwich Mean Time (aka UTZ). Can you change the timezone in the sync field (which clearly shows GMT)? The change from GMT to PDT is why you’re going back in time, anytime a date field doesn’t have an included time it’s assumed to be 12:00AM, so when it converts from GMT to PDF it goes backward. 

Terms & ConditionsAccessibility statement