Different timezone with automation from google sheet to AT

[SpelaU]

Hi guys!

I'm using Ubiqod for attendance tracking in our company. When you scan code, you click on the correct button (arrival, break, going home). After you submit it, the data comes to google sheet and with automation it gets to the Airtable. 

Now the problem occured. The timestamp from the google sheets it's not the same in the airtable. My guess is that this has got to do something with the different timezones. In googlesheet it's correct timestamp, in airtable it's 2 hours later.

This is timestamp from google sheet:

This is timestamp from AT:

How can I transform this date in AT so that the hour will be correct (it was supposed to be "14:07" not 16:07). 

Thanks!

[TheTimeSavingCo · Accepted solution]

It's likely that it's a display issue and not a data issue.  Could I confirm your date field is set to the desired timezone? 

 

[SpelaU]

Omg, it's that simple. This was the issue yeah. Thank you @TheTimeSavingCo !