Date format MMM-YY, will not be in correct order.

[#1]

Hi.   I got a strange issue regarding sort of date with format MMM-YY. This is also the data input. I can not get QV to sort on this format. But if a set YY-MMM, then it works, but I prefer MMM-YY. How do I do ?

[sunny_talwar]

How are you assigning the format? Can you share the expression or script?

[MarcoWedel]

You most likely didn't Get the Dates Right

Try to load your date field as dual value e.g. like

Date#(YourField, 'MMM-YY')

hope this helps

regards

Marco