What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Why do dates not enter (sort) correctly?

    Asked by atrsports on May 22, 2012 at 03:21 AM

    So, for the most part, I love your forms.  Forgive my rant, but the genius you have poured into the REST of the website would seem to be more than adequate to solve this problem...

    When I ask for Birth Date on the form, it translates to "MONTH DD YYYY".  That doesn't even work (sort) correctly on your own Submissions page, much less on an exported spreadsheet.  The reason I went with a form builder is to save time.  Having to manually input commas in each date after I export the data seems like such a waste of time!

    How do I fix this?

    Page URL:
    n/a

    Screenshot
  • Profile Image

    Answered by gori-mathew on May 22, 2012 at 07:04 AM

    Helo;

    We apologize for the inconvenience caused.You should use the "Hint" feature. That will show up in a light color by default and become invisible when the user clicks on the form. Here is an example:

     

    You can also look at the below links of previously answered questions on this area for more guides,

    https://www.jotform.com/answers/24691-I-have-2-named-date-fields-arrival-departure-

    https://www.jotform.com/answers/67597-how-to-add-date-format

    Lets know if this works out!

  • Profile Image
    JotForm Support

    Answered by abajan on May 22, 2012 at 08:39 AM

    @atrsports

    After downloading your submission records and trying to sort the Birth Date field, I see what you mean. I will submit a ticket and hopefully we can get our default Birth Date Picker fields to automatically insert a comma after the day, as highlighted below, in submission records as well as email alerts:

    January 19, 2012

    However, preliminary tests indicate that Date Time fields (which are output in a different format: 01-19-2012) would be a viable alternative while we sort this out (no pun intended).

    Thank you for drawing this to our attention.

  • Profile Image

    Answered by marehard on October 24, 2012 at 05:34 AM

    Problem still not solved!!

  • Profile Image
    JotForm Support

    Answered by Rodjit on October 24, 2012 at 05:55 AM

    @marehard,

    A ticket about this request is still opened. Our developers will updates us once this get fixed or they do have any development about it.

    Our developers are working for updates depending on priorities so please have us your patience.

    Thanks

  • Profile Image

    Answered by marehard on October 24, 2012 at 02:06 PM

    I would like to use your service. actually i'm using allready one form in real life and would like to upgrade.

    but if your forms are not able to save a correct date-format in the database, this is an k.o.-criterium for me (and surely for many others!). i need to sort my entries by date!

    if your developers are not able to save a correct date-format in 5 months, then you should tell them, that this is a critical problem.

    best regards!

  • Profile Image

    Answered by moonzkie on October 24, 2012 at 02:42 PM

    I'm truly sorry but we don't have any updates yet. I have already notified our developers about this. We'll keep you posted if any information's available. Thanks for your patience.