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

    Report won't sort by date

    Asked by bmaj on May 26, 2014 at 05:40 AM

    I've made a table report that I want to sort by date but when I click the header in the report, it doesn't seem to have any sort order at all - not alphanumeric nor American date format (using UK date format).

    Any ideas?

    Actually, according to other posts, looks like a bug.  Picked up in April: ETA for fix?

    Page URL:
    http://www.jotform.com/table/41452114553042

    table table report format american date
  • Profile Image

    Answered by bob on May 26, 2014 at 08:00 AM

    I've just looked into your "Book ICT Equipment" form and the table report you created. I've tried to sort the date function in different ways but failed. I also created an Excel report and a grid report but wasn't able to sort the date.

    But as I cloned your form and tested with creating table report, the date function sorted very well either in descending or ascending order.

    It seems you didn't set "Default Time/Date" to ON mode while adding the Date/Time field to your form.

    Please let us know what happens if you recreate any report with new submissions after setting "Default Time/Date" to ON mode.

    Thank You.