Date field not sorting by date - HTML Table Listing report

  • Profile Image
    WSMC
    Asked on November 03, 2014 at 08:06 AM
    Hi,
    Just checked and no they are not sorting on date
    http://www.jotform.com/table/43061668052048
    Regards
    Ben
  • Profile Image
    Charlie
    Answered on November 03, 2014 at 09:07 AM

    Hi Ben,

    I've checked your form and it does seem that it sorts incorrectly. Have you tried to edit the submissions "Date" field manually? Or have you changed the time format once and reverted it back? I would recommend that you use the Grid Listing Reports, it works correctly with your date field.

     

    I hope this works. Let us know if you needed further assistance on this.

    Thank you.

  • Profile Image
    WSMC
    Answered on November 04, 2014 at 06:01 AM
    Hi,
    I need the HTML listing so will wait and see if you come up with a fix
    Thanks
    Regards
    Ben
    ...
  • Profile Image
    ashwin_d
    Answered on November 04, 2014 at 07:59 AM

    Hello Ben,

    Yes you are correct. The sorting feature of date field with DD/MM/YYYY format does not seems to work correctly. I did test it an I am able to replicate the issue you are having. Please check the screenshot below:

    I am reporting it to our back end team. We will get back to you as soon as we have any update form them.

    Thank you!

  • Profile Image
    alp_deniz
    Answered on August 26, 2015 at 12:02 AM

    Hello,

    Date sorting of dd-mm-yyyy fields are now fixed. Thank you very much for letting us know!

    Kind regards

  • Profile Image
    gerhardwerner
    Answered on January 28, 2016 at 12:12 PM

    Hi alp_deniz,

    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
    Charlie
    Answered on January 28, 2016 at 01:29 PM

    @gerhardwerner

    I opened a separate thread so that we can better assist you, please refer to this link instead: http://www.jotform.com/answers/758782. We will address it shortly.

    Thank you for your understanding.