Sorting mmm-yy dimension

[#1]

Hi,

I have a data load with the date format in mmm-yy. I have attempted to sort it in a variety of ways and not being successful. I am assuming i need to change the format? Can i do this in the expression part of the sort - or will it need to be done elsewhere and what will i need to do?

Thanks

James

[tresesco · Accepted solution]

Try sort expression like:

=Date#(YourDateField, 'MMM-YY')

If this doesn't work , try to share your sample qvw.

[Miguel_Angel_Baeyens]

James,

In those cases I always create a numeric, integer field in the calendar table that goes from 1 (first month in the calendar table) to n (last month in the calendar data), and then use this field in the Sort tab of the objects to sort by expression.

Another option, should that field is coming from a Date() function is that, given that it already has a numeric value, use it for sorting. If otherwise it's a string field where you just concatenate the month and the year, then the first solution of an extra field in the calendar table will do.

Miguel

[#4]

Hi,

Many thanks for that.....so simple! It has worked.

Thanks