Read Months value in calendar order--not ABC order
I have been trying to fix this for a while now. I have a variable- vCurrentFiscalMonth (imported from the master calendar) which would result in (JUL), but when I do certain search expressions (vital to my project), it is not working properly because the months are being read in alphabetical order. I have already tried adding an in-line rank and have played around with many different settings under Sort.
Note: I did not create this dashboard or script. I am only making some changes to it.
Here is what part of the script looks like:
Where I have noticed this issue:
The result should give me all the months before (and including) July, but is giving me the ones before in ABC order.
Also, if I try to get the previous month like this, I get no results.