My year field is not able to sort from high to low ?

[paulyeo11]

Hi All

I create a calendar , my year field able to give me in number is working fine , except that it unable to sort from hi to lo. can some one advise me ?

year([date])

as [year],

Enclose my QV doc.

Paul

[#2 · Accepted solution]

It is sorted from hi to lo???

Otherwise, sort by numeric value descending, or sort your datekey descending in your script, however then you have to reverse your dates, because it would sort all dates desc.

[paulyeo11]

Hi sir

I found my mistake , i can only tick on load order , and it will work , i make a mistake to tick on sort by number order , because i thou this is number field , so number sort must be on.

Now i know load order is more impt to make the sort work.

Paul