Date is not being displayed correctly in integrated google spreadsheet.

  • annieslocker
    Asked on February 26, 2018 at 9:51 PM

    Hi,

    In our google sheet the submission dates are coming in like this 43152.5715625

    There doesn't seem to be any logic to it.

    Also, the date of birth comes in like this 29752

    They were both working, not sure when this started, we think around May 2017.

    Thanks


  • Ashwin JotForm Support
    Replied on February 27, 2018 at 3:03 AM

    I cloned your form and integrated it with google spreadsheet. When I tested cloned form, the date of birth column is displaying correctly in google spreadsheet. Please check the screenshot below:

    1519718331GSDate Screenshot 10


    Have you changed the format of the spreadsheet column? I have synced your google spreadsheet again. I would suggest you to please check your google spreadsheet and see if the date it being displayed correctly. 

    If the issue persists, I would suggest you to please re-integrate your form with google spreadsheet and see if that solves your problem.

    Do get back to us if the issue persists.

  • annieslocker
    Replied on March 1, 2018 at 2:32 PM

    That worked thank you.