months filter sorting

[ilanbaruch]

hi all

in QS Filter pane Months field can be sorted ascending or descending by its numeric value.

but how can the current month can be set to the first value in the list ?

any ideas ?

advanced thanks

[Or]

Custom sort by formula, e.g.:

if(MonthName(Month)=MonthName(Today()),1,Month)

It's probably better and cleaner to make a Is_Current_Month flag in the script, and then custom sort by the flag (0 = yes, 1, no) and secondary sort by numeric value.

If you don't like the idea of custom sorting, you could also load your months pre-sorted in the script (using the sane type of condition), and then uncheck all of the sorting options to make QS sort by load order.