Google Docs/jotform date format

  • Profile Image
    sander_j4s
    Asked on July 06, 2012 at 03:30 AM

    Hi

    I found issues with the date format of jotform. Sometimes, jotform records a date like this:

    jotform1

     

    And sometimes, jotform records a date like this:

    jotform2

     

    Why does it do that? I have this form synchronized with google docs, and it results in this:

    google docs

     

    Also, for some weird reason, this is in the dd-mm-yyyy format, while ALL OTHER RECORDS are in the mm-dd-yyyy format. This is VERY CONFUSING. How am I to know if someone is entering a date like 'Januari 2', of 'February 1'? This makes it impossible to sync google docs to google calendar..

  • Profile Image
    ItalyTech
    Answered on July 06, 2012 at 03:55 AM

    Hi and thanks for contacting us. I report this issue to our developer. Can you indicate us your form ID please ? We let you know when we ave any news about this.

     

    Thanks. Alessandro

  • Profile Image
    sander_j4s
    Answered on July 06, 2012 at 10:58 AM
  • Profile Image
    liyam
    Answered on July 06, 2012 at 02:52 PM

    Thanks for the information, sander_j4s.  Once we have updates, we'll sure to let you know.

    Warm regards,

    Liyam

  • Profile Image
    sander_j4s
    Answered on August 01, 2012 at 03:26 AM

    Still no news on this?

     

    Sander

  • Profile Image
    pinoytech
    Answered on August 01, 2012 at 03:31 AM

    Hi,

    Sorry to tell sander_j4s to tell you that this issue isn't resolve yet by our developer. Don't worry as soon as our developer fixed the issue we will inform you immediately.

    Thanks for the patient!

  • Profile Image
    NeilVicente
    Answered on March 05, 2013 at 08:55 PM

    Hello Sander,

    We are sorry for the really delayed updates, but I would like to let you know that I have applied a fix to this problem.

    The date values are displayed as numbers on the submissions page when they do not follow the date field's format. For example, Jelle Polder mistyped the date (dd-mm instead of mm-dd).

    I have also found a few other submissions on your form exhibiting this behavior:

    The above example happened because month was written as '2' instead of '02'.  The fix I applied should resolve this issue.

    On the other hand, Jelle's case is obviously caused by user error, and the only way to rectify such is to edit the entry from the form's submissions page.

    Hope this post helps.

    Best regards

  • Profile Image
    sander_j4s
    Answered on March 08, 2013 at 04:55 AM

    thanks for the update! Guess it's up to me to prevent the user from being able to make this mistake :)