Skip to main content
Solved

Force Automation to not just copy and paste the Training Started Field, but also hard code to 6:00am PST

  • July 16, 2025
  • 2 replies
  • 41 views
Sean_Lake1
Forum|alt.badge.img+20

 

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!

Best answer by DisraeliGears01

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. 

2 replies

Sean_Lake1
Forum|alt.badge.img+20
  • Sean_Lake1
  • Author
  • Inspiring
  • 113 replies
  • July 16, 2025

Heres’ before the automation runs above:

 

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

DisraeliGears01
Forum|alt.badge.img+21
  • DisraeliGears01
  • Genius
  • 301 replies
  • Answer
  • July 16, 2025

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