- TerriHAsked on August 12, 2015 at 10:35 AM
Lately, as I have gone in to sort our submissions, they are not sorting correctly when it's by dates. For example, we have a column called "Final Art Due Date". When I go in to sort this column in descending order, it doesn't sort it correctly.
At first, I thought it was the date format we using. So, I went in and changed all them to be consistent. But, that didn't work either.
Can you help me out?? :)
(I've attached a screenshot where I have sorted the "Final Art Due Date" column descendingly. Also include the url.)
- JotForm SupportEltonCrisAnswered on August 12, 2015 at 12:22 PM
Sorry but I see no problem on your screenshot. It shows the data in descending order base on "Final Art Due Date" field not with the submissions date, just to clarify.
If you'll focus on that column only, you see the dates are sorted in descending order.
Perhaps what you need is to sort them base on the submissions date?
Please take note that the data grid does not support sorting base on multiple columns. It can only sort data base on a single column.
- TerriHAnswered on August 12, 2015 at 12:35 PM
Sorry about that. I did not take the correct screenshot apparently. I actually can't give you a correct screenshot as we have had some additional forms submitted and I can't get my screenshot big enough to show you what it's doing.
But after digging through it some more, I believe it's because of how the dates are formatted. I may have fixed the problem.
If not, I'll let you know...lol
- JotForm Support ManagerJeanetteAnswered on August 12, 2015 at 02:13 PM
Glad to know you have fixed the problem. Let us know should you need further help.