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

    HTML Table Listing: Date fields are not sorting properly on ddmmyyyy format

    Asked by gerhardwerner on January 28, 2016 at 01:28 PM

    I've tried it just now, but it seems sorting of dd-mm-yyyy in the html listing is not fixed. Any idea what to do? Grid is ok, but i need html :-(

    Many thanks

    Gerhard

  • Profile Image
    JotForm Support

    Answered by Charlie on January 28, 2016 at 01:35 PM

    Could you please provide us your HTML Table listing report that has problems on the sorting of the submission date field? And/or the form that is associated with it? I see you have a lot of forms being updated in your account.

    Here's mine: https://www.jotform.com/table/60275494530052. So far, the submission date is properly sorting. We'll wait for your response.

  • Profile Image

    Answered by gerhardwerner on January 28, 2016 at 01:41 PM

    Hi Charlie,

    Many thanks for your fast response. Of course, the listing report is http://www.windhund.at/wurfmeldungs%C3%BCbersicht/wurfmeldungen2015.html (at the very bottom of the page!).

    The form is https://form.jotformeu.com/60272564279360.

    Hope that helps.

    Many thanks
    Gerhard

  • Profile Image
    JotForm Support

    Answered by BJoanna on January 28, 2016 at 04:32 PM

    I am not sure if I understood your issue correctly. 

    I have inspected your report and it looks like this.

    Format of the date is dd.mm.yyyy, because that is the format of your DateTime field. 

    If you want that format of your date is dd-mm-yyyy, then inside of Form Builder select you DateTime field and set Separator to -

    Here is my report with both options: https://www.jotform.com/table/60276238851055 

    Let us know if you need further assistance. 

  • Profile Image

    Answered by gerhardwerner on January 29, 2016 at 03:00 AM

    Hi BJoanna,

    not the separator is the problem. It's working properly. If you look at the html listing you can see in the second column "Wurfdatum". This column isn't sortable, but this is one of the most important columns of the table for my users.
    Every other columns are sortable but this is the only one which isn't.

    Many thanks
    Gerhard

  • Profile Image
    JotForm Support

    Answered by Charlie on January 29, 2016 at 09:14 AM

    I was able to replicate the problem. It seems like this happens when you are using the ddmmyyyy format.

    Here are the sample HTML table listing reports:

    https://www.jotform.com/table/60284165370049 

    Noticed that in the year 2015, the months are alternating in this case, January and February months are alternating. It seems like it sorts the days without considering the month.

     

    https://www.jotform.com/table/60284196846061 

    Noticed here in the year 2016, the months are also alternating, and it sorts by days.

     

    I have forwarded this to our developers to have it checked and fixed. Apologies for the inconvenience.

  • Profile Image

    Answered by gerhardwerner on January 29, 2016 at 12:23 PM

    Hi Charlie,

    no reason for excuses. Jotform is my one and only form generator for all my websites. I'm very satisfied with Jotform and with your support.
    Many thanks for your help.

    Have a great weekend!

    Gerhard

  • Profile Image
    JotForm Support

    Answered by Charlie on January 29, 2016 at 01:26 PM

    Thank you for your understanding and the kind words. We make sure that we take note all of your feedback and use it to improve the overall experience you have in our form builder.

    We will update you on this thread as soon as this problem has been resolved. 

  • Profile Image
    JotForm Support

    Answered by alp_deniz on February 14, 2016 at 09:45 PM

    Hello,

    The problem with the date sorter is now fixed. It seems that dot (.) separator was not handled correctly.

    Thank you very much for letting us know

    Kind regards