Date/Time to Airtable

Fighting this two days and counting :laughing: 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.