Problem with Google Sheets, dd/mm format go to mm/dd

  • Profile Image
    leo8nardo8
    Asked on December 28, 2015 at 07:39 AM

    I'm having this problem

    This is in the JotForm Answer

    And in the Google Sheets, this date come like this

     

     

    In my form, the date format is set DD/MM/YYYY, and all the submissions are OK, but in the Sheet i'm having this format problem.

     

    How can I solve this?

  • Profile Image
    victor
    Answered on December 28, 2015 at 09:34 AM

    Sorry for this inconvenience. I have just cloned your form and was not able to recreate your issue. Could you please try to re-integrate your spreadsheet and see if this resolves the issue.

    If you still experience this issue, please let us know and we will be glad to take another look.

  • Profile Image
    leo8nardo8
    Answered on December 29, 2015 at 05:38 AM

    I try to re-integrate my spreadsheet and I didn't have the same issue.

    Thank you.

  • Profile Image
    Charlie
    Answered on December 29, 2015 at 10:29 AM

    Glad to hear that re-integrating resolves your problem. Should you need any assistance again, feel free to contact us here in the forum.

    Thank you.

  • Profile Image
    leo8nardo8
    Answered on December 30, 2015 at 02:39 PM

    I have already re-integrate 3 times my sheet.

    Every time I re-integrate the problem is solve, but when I get new submissions this erros repeat.

    Look at the last answer, they come with a diferent format, and this cause me problens in others sheets.

     

    What should I do?

  • Profile Image
    david
    Answered on December 30, 2015 at 06:06 PM

    It could be that the format of the spreadsheet is not the correctformat  and it needs to be changed, or you can change the format of your date fields to mmddyyyy.

    This should change the fields automatically to the proper format.

  • Profile Image
    leo8nardo8
    Answered on December 30, 2015 at 06:52 PM

    Thanks, it works!!

     

    :D

  • Profile Image
    Mike_G
    Answered on December 30, 2015 at 10:33 PM

    On behalf of my colleagues who helped you with your concern, you're most welcome! Feel free to contact us anytime if you have any other questions or concerns. Thank you.

  • Profile Image
    leo8nardo8
    Answered on January 13, 2016 at 06:25 AM

    Guys everytime I get new submissions I'm geting problems.

    They with 3 diferente format, and I cannot correct.

    Before the integrate they come with the format dd-mm-aaaa hh:mm:ss

    After integrate 5 submissions come with MM/DD/aaaa hh:mm:ss

    And the last 3 come tiwh DD/MM/AAAA hh:mm:ss

     

    Same thing in another column

    Before integrate dd/mm/aaaa

    After integrate 4 with dd/mm/aaaa

    3 with mm/dd/aaaa

    1 with dd/mm/aaaa

     

    Help pls :)

  • Profile Image
    victor
    Answered on January 13, 2016 at 09:01 AM

    Sorry for this inconvenience. I have retest the integration and was not able to replicate the issue. Could you please indicate if this occurs randomly, at certain times, and with the format already set.

    I will submit forms for a couple of hours and see if I can replicate the issue. If I'm able to replicate the issue, I will keep you informed.

  • Profile Image
    leo8nardo8
    Answered on January 13, 2016 at 09:06 AM

    When I re-integrate the form all the "past" date come with the same format. But after the re-integrate when I get new submissions the format os dates changes.

    It seems to be randomly. I tried to set the format to the cells, but didn't work to me.

    Thanks for the help.

     

  • Profile Image
    victor
    Answered on January 13, 2016 at 10:59 AM

    Thank you for the update. Like I mentioned, I will be tested on the course of the day. At the moment I have submitted forms but was not able to replicate the issue you are having.

    I have played with the format in the spreadsheet, but it does not change when I submit the form. If I find anything, I will let you know.

  • Profile Image
    leo8nardo8
    Answered on January 14, 2016 at 12:08 PM

    Any news?

  • Profile Image
    victor
    Answered on January 14, 2016 at 01:23 PM

    Sorry for not getting back you sooner. I have been testing the spreadsheet integration. At the moment I was not able to replicate the issue you are having. I have modified the format many times as well as remove and integrated the spreadsheet.

    The dates are always entered in the same format.