JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How do I pass a date from JotForm to Google Calendar correctly?Asked by MyPartySupplies on August 12, 2016 at 05:23 AM
I created a JotForm which requires a booking date and time field. I'm trying to use Zapier to pass that data as a detailed calendar entry to Google Calendar.
I have set the time zone in Google Calendar, JotForm and Zapier to the same time zones (Africa, GMT+2) but the entry always appears with the dates in reverse order - it transposes the Month with the Day.
For example: If I select today (12-08-2016 in the format DD-MM-YYYY) the entry appeas on December 8th 2016. In other words it has put the month ahead of the date.
Any guidance would be appreciated in fixing this!
It appears that this is a duplicate thread. However, I see that this has further details on your exact concern. Please disregard my response on the other thread.
I believe the date format needs to be the same on Jotform so it can be passed correctly on Google Calendar. Can you try changing the format on jotform to MM-DD-YYYY so that the date can be passed correctly?
If the issue persists, please let us know.
I have set the JotForm to DD/MM/YYYY (which was my original setting, although I also tried MM/DD/YYYY) - neither setting seemed to make any difference.
If I look at the submission on Jotform they seem to show the correct date based on the format selected (either DD/MM/YYYY or MM/DD/YYYY) - so I assume that this data is being correctly passed to Zapier but the end result is still incorrect.
Somewhere, something is manipulating the date - I have even tried in Account >> Settings to change the date/time format from ISO to US to EU-Asia but that doesn't appear to make any difference either.
Thanks for the additional input. I'm currently fiddling around Jotform > Zapier > Google Calendar workflow and will update you once I find something, thanks in advance for your patience.
All right, I managed to get it to work and wasn't able to replicate the problem you mentioned (where the dates and months are interchanged, regardless of what date format, timezone or time format you set on your form and account settings)
Here's how I filled out my cloned form:
Here's how I received the trigger in Zapier:
And here's how it was logged in my calendar:
As you can see on all screenshots, the date is consistent to be Aug 16, 2016 and the MM and DD were not interchanged.
My setup for this test were as follows:
1. Timezone: Singapore (GMT+08:00)
2. Time Format: EU-Asia - DMY
3. Date Field format: ddmmyyy
1. Create Detailed Event (Google Calendar)
2. Fields Date was selected as the Start and End dates (Google Calendar)
I would recommend you try setting up your Zap again and ensure you haven't missed anything. Also, if you there are any unique steps that you're doing that will help us replicate the problem, please let us know so we can give it a try.
Otherwise, from how I see it, the workflow from Jotform to Zapier to Google Calendar works just fine.
Thanks for the detailed information - and for your extensive explanation.
I am grateful for your help!
1) I will set up the Zap again to make sure I didn't miss anything.
2) May I ask you to test your zap with today's date? 12 Aug 2016? Given that the date you chose for your test could not lead to a transposition as there is no 16th month.
Really appreciate your time!
Thanks for that bit of info, I managed to replicate it now and the issue appears to happen when the date is less than or equal to 12. Since it's the effectively Saturday now on my end, 13th, I selected Sept 12 instead. And there it was, the dd and mm were interchanged:
I checked how it was pushed to Google Calendar and confirmed an event was added for Dec 9 too.
However, the issue seems to start with Zapier. I checked the DATA OUT from Zapier's Task History and JotForm pushed the correct date in the correct format (ddmmyyyy)
fields__Date: 12/09/2016 2:00 PM
For some reason, Zapier interchanges the dates and I'm afraid that's something beyond our control.
I managed to find a similar thread here https://www.jotform.com/answers/197595 Although this isn't the same as the issue you're having now, he's doing the same integration as you (Jotform > Zapier > gCal) and using the Quick Add Event trigger for Google Calendar worked as a workaround for him (e.g. Add a quick event and pull the date as a field)
I ran another test for Add Quick Event trigger this time and it worked perfectly. The dates were not interchanged:
To sum it up, if you really prefer to use the Detailed Event trigger, please try contacting Zapier. Or, refer to this help page on wrong dates/times https://zapier.com/help/google-calendar/#my-events-aren39t-showing-up-on-the-right-date-or-time
If you're okay with the Quick Add Event trigger on the other hand, give it a try and let us know how it goes.
Thanks again for your time and effort - it is appreciated.
Just as an FYI
1) Am 'glad' you were able to replicate it - means I'm not going mad. ;-)
2) When using the same zap - and using the 16th of August (as you did) the calendar entry was correct as well - so your summation appears to be correct.
3) I will ask Zapier to look into the matter.
4) May I refer Zapier to this thread so they can see the issue and the extensive troubleshooting you have done?
Thanks once again.
In my colleagues name, you are welcome.
In regards to the thread link, please do - it should speed up the process for them to see what happens.
To do so, you can give them this link: https://www.jotform.com/answers/904707