Forum Discussion
Solved
date Sorting
Hello, I created the following columns and was confused with the sorting of the Month/Year . I still keep ketting February prior to January. Any thoughts
Thansk Again Phil.
I will remove Weeks and then only use Month/Year and DD fields.
I went to the modeling tab and sorted the data by M/Y Sort. It did the trick. Thanks again
Do you have a separate DATE table with 1 row per day?
If not, I recommend you do for more reasons than this. It will make sorting and hierarchies tidier.
So at the very least add the following table
Dates = CALENDARAUTO()
And then create a relationship between this table and your Query table