I have a scenario with incomplete executions turned on.
In this particular scenario, I’m uploading photos or videos to Instagram.
I’m using a Break module to catch errors; try 3x every 5 minutes.
In this case, the IG module had errors but then resolved on the 3rd try.
The next module updates a record in Airtable.
But the Publish Date column is showing the wrong date/time when using the ‘now’ function provided buy Make.
Why is the date/time wrong?
Please see attached screenshots.
Your Airtable might be set to a different timezone. Check your Airtable settings.
For more information, see
Hope this helps! If you are still having trouble, please provide more details.
— @samliew
Hello,
Take a look at the helper text - {{now}} will use time in the America/New_York timezone. You probably have a different setting in your database.
By default Airtable stores data in GMT timezone- Timezones and Locales In Airtable | Airtable Support
Try to format date using example function:
{{formatDate(now; DD.MM.YYYY HH:mm:ss; "UTC")}}
Where UTC specifies timezone in your Airtable database. Learn more about tokens: Tokens for date/time formatting - Help Center
You can learn more about time in Make here- Date and time functions - Help Center
Personally I recommend using time in UTC and then format it using Airtable formula in separate field.
Examples:
Airtable Date field without option Use the same time zone for all collaborators
{{formatDate(now; "DD.MM.YYYY HH:mm:ss"; "America/New_York")}}
{{formatDate(now; "DD.MM.YYYY HH:mm:ss"; "UTC")}}
