Google Spreadsheet integration records date or datetime values as a whole number

  • Profile Image
    oswaldocruzquimica
    Asked on November 03, 2015 at 10:27 AM

    Hello Kemalo

     

    My problem return to happen, would you mind helping me?


    It´s same problem, i put the right configuration, but when the integration with JotForm and Google sheets, happen the date is filled wrong.

     

    Regards.

    Dener Leão

  • Profile Image
    Welvin
    Answered on November 03, 2015 at 10:51 AM

    Hi Dener,

    Did you try my previous suggestion on September 09, 2015 to manually set the "Locale"? Here's the link to my reply: https://www.jotform.com/answers/657256#658107.

    Now, if that is not working, please try to re-integrate the form again to Google Spreadsheet and this time, please check the option to Pre-Format the date field.

    Thanks

  • Profile Image
    oswaldocruzquimica
    Answered on November 03, 2015 at 12:06 PM

    Hello, Kemalo

     

    Thank you so much.

     

    I apply this sugestion, and now thaa`s ok.

     

    Thank you a lot.

     

    Regards.

    Dener Leão

  • Profile Image
    Welvin
    Answered on November 03, 2015 at 02:22 PM

    That's great to know! Please contact us again if we can help in any way.

    Thanks