Fighting this two days and counting My Airtable “Create a Record” module is not passing the correct date/time from a webhook to Airtable. I’m getting {October 23, 2024 4:01 PM} from my webhook, but {October 22, 2024 7:00 PM} is getting passed to Airtable.
Hello @Mike_Fetherling,
If you’re using now
which always parses the date based on Organization Timezone.
If you already used datetime which comes from your webhook then parse it and use that.
If still get issues then please share your more detailed screenshot or some sample of your webhook data with what is the exact output you need.
Make use of organization time zones and user time zones differently.
Read more about how Make’s timezone settings work.
https://www.make.com/en/help/general/manage-time-zones#manage-time-zones
Here is another trial and error: October 12, 2024 10:24 AM is bing input to the Airtable module and October 12, 2024 12:00 AM is coming out of it. Here are screenshots of the setup I used to get this result:
Hello @Mike_Fetherling,
I think there are issues with your date format. Carefully check what I’ve used.
In the example, I’ve used Static Date, Change it according to your variable.
Suggest you store that parsed date in the variable and then use that variable in the Airtable field. That became more cleaner approach.
I hope this works for you.