- DawsonsIntranetAsked on November 01, 2013 at 09:03 AM
We are using a form (ID 32883009129961) for our Rentals database. A couple of days ago, the Start Date and End Date were working fine (in the format dd/mm/yyyy) when appearing in the linked Google spreadsheet, but today (01/11/2013 - UK format) the dates being entered into the spreadsheet are showing as 11/01/2013 - ie, 11 January 2013. Why has this changed? If I double click on an entry in the spreadsheet which is displaying 31/10/2103, the calendar for October opens, but if I do the same on an entry from today it displays January 2013.
- KadeJMAnswered on November 01, 2013 at 11:00 AM
Actually the UK Format of " 11/01/2013 " is known as November (11th Month) of Day 1 (1st Day out 30 Days for the Month) with 2013 being this Year and not 11 January 2013. It's just reversed from what is commonly known which may seem confusing to many.
I checked your form but the date seems fine so it is likely that just the Date and Time Stamp for Google Spreadsheet recieving the Submission of the form may have possibly changed.
I think that this " Submission Date " Format below is possibly converting itself on your end to the UK Format you mentioned. I also recall not to long ago someone requesting a feature for something along these lines but it was supposed to be Optional I think.
I checked on this further with a Date Test and connected it to Google Spreadsheet and it looks like we've made a recent change but I'm not seeing a way to revert it as I do not see an option for such. I will have to look into this more to see if something can be done to put it back since right now I'm not too sure but will try to figure this out more in case there is a way to do so. I will speak with our Developers about it.
Date Test Form: http://form.jotform.co/form/33044589581865
Date Test Google Spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AoQfICZ3OH3ldEJueGEzNDRFeVd0VlJJTDlFR2FQa3c&usp=sharing
Screenshot for Comparison:
- DawsonsIntranetAnswered on November 01, 2013 at 11:26 AM
Please can you try filling in the form once with a start date of 30/10/2013 and once with a start date of 01/11/2013 for me? I would be interested to see if you get the same results - ie the first one is correct in the spreadsheet and the second one is wrong.
- EliezerNAnswered on November 01, 2013 at 01:48 PM
Thanks for contacting us.
I tested one of my forms using the format ddmmyyyy to be sure to if the issue is happening from our side too, and I was able to reproduce the issue in the spreadsheet.
However, when I changed the format to mmddyyyy in the form, the spreadsheet shows the result correctly:
So, it could be that the format of the spreadsheet is not the correct one and it needs to be changed, or you can change the format of your date fields to mmddyyyy.
- DawsonsIntranetAnswered on November 04, 2013 at 06:48 AM
Thanks for having a look at this. I need to keep the spreadsheet (and the form) formatted as dd/mm/yyyy. The form has been used twice over the weekend with the same result. I don't understand why the date was correct when 30/10/2013 was picked, but not right when 01/11/2013 was picked. The spreadsheet hasn't changed! I was wondering if, when 30/10/2103 was keyed, JotForm tried to format it into mm/dd/yyyy and couldn't, so defaulted to dd/mm/yyyy. Why else would 30/11/2103 work but 01/11/2013 not?
- EliezerNAnswered on November 04, 2013 at 10:08 AM
Thanks for contacting us.
We deeply apologize for the inconveniences this may have cuased. I'm still looking for the possible cause of this behavior in the spreadsheet.
Please let me do some final tests with my integrated form and if I can find something helpful will notify asap, otherwise, this may require to be forwarded to our next level support.
At any rate, I will let you know my results.
- JotForm SupportWelvinAnswered on March 26, 2016 at 12:15 AM
@feuny Please proceed on this link (https://www.jotform.com/answers/803060) for your problem.