Dates are not in order in slider object

[mohan2391]

hi

I concatenated 2 fields as 3rd field like this

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

where revenue is my field.

My doubt is when i created a Slider object by taking the filed as date, I'm getting the slider but the dates are in alphabetical form like Apr2014 then Apr2015 then Dec2014 then July2014 etc

But I want in the order of Apr2014-July2014-Dec2014-Apr2015

how can I get it ?

Please help me

Thanku

[tamilarasu]

Hi Mohan,

Go to slider property and select sort tab.

Write the below in expression tab.

=Match(date,' Apr2014' , 'July2014' , 'Dec2014', 'Apr2015' )

[Gysbert_Wassenaar]

You created a text field that can only be sorted alphabetically. Instead try the Date() function to format the date, but leave it a date value: Date(RevenueDate, 'MMM-YYYY') as date. Then sort that field numerically in the slider.