Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikQlaker
Contributor III
Contributor III

Sort by date and time

I'm having an issue sorting dates (with and without times).  

So far, I've tried about every combination of Date#(date,'MMM-YY') that I've read in every other post and the thing that is finally coming closest to working is to add a whole other data point for the update date, pull out the month /  year, and then sort by that. 

The issue (as shown in the pic) is that some of the date randomly don't sort properly.  I have no idea what is causing this, the sorting column is solely pulling in the above month/year combo.

Help!

1 Reply
QlikQlaker
Contributor III
Contributor III
Author

And also, this...