Dates in slider object are not in correct order

[mohan2391]

hi

I concatenated 2 fields like

month(RevenueDate)&'/'&year(RevenueDate) as date

where RevenueDate is my field.

Now I created a slider object by taking the field as date. Then i'm getting the slider values of date are in alphabetical order like

Apr2014 then Apr2015 then Dec2014 then July2014 etc.

But I want them on slider as

Apr2014-July2014-Dec2014-Apr2015 etc.

How can I get it.

Please help me.

[marcus_sommer]

The reason is you have a string created which couldn't be numeric sorted. This meant you need a numeric value behind your string, maybe in this way:

dual(month(RevenueDate)&'/'&year(RevenueDate),

     (year(RevenueDate) * 100) + num(month(RevenueDate)))

- Marcus