Sorting Data error

[SorinDiaconescu]

Hello.

I have a date column I want to sort. Using the sort option I mark it as sorting descending and it does sort the years, but not the month or day. any ideas why?

 

[LordNeilLord]

Hey @SorinDiaconescu

It sorted fine for me when I did a quick test!

Can you share some data?

[SorinDiaconescu]

Here is a small sample. I cant share more.

Thanks,
Sorin

[LordNeilLord · Accepted solution]

Hey @SorinDiaconescu

It worked fine for me, i did notice that the sort is messed up if you have the "use dictionary order" button ticked

[SorinDiaconescu]

So funny. I unticked the box and it sorted perfectly. thanks

[ronvv]

Thanks for this tip....I had a similar issue and unchecking the box appears to have resolved it