Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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