- kaylaheffernanAsked on December 11, 2017 at 01:05 AM
The submission date field (hardcoded) is coming through as MM/DD/YYYY. This previously was not the case and has just started happening.
I've tried to override in Google Sheets with date formatting but it isn't working as it's taking the day as the month. The timezone of the account is set to Melbourne AU
- JotForm SupportamyAnswered on December 11, 2017 at 07:00 AM
I cloned your form on my end in order to check it in detailed. I have also integrated my cloned form with the Google SpreadSheet integration. I sent two test submissions by myself. However, I am unable to replicate the issue. Please check my result.
I kindly recommend you to remove your current integration and integrate your form with the Google SpreadSheet again. This process will push all of your current submissions to the new spreadsheet again. If your problem persists, please let us know.
- kaylaheffernanAnswered on December 11, 2017 at 07:14 AM
Thanks, that's fixed the problem!