Custom MonthYear range in a slider! How to do it ?

[#1]

Hi,

I am looking to have a custom date range in a slider. I have a master calendar loaded and the start date is "01/01/2012" and the end date is "12/31/2014". I have around 20 tabs in my application and each tab has a slider with MonthYear of the Master Calendar as its dimension. So the span or MonthYear from start and end date is Jan 2012 to Dec 2014. All sliders diplay the range from Jan 2012 to Dec 2014. What i'm looking to acheive is I want some sliders range from Jan 2012 to Sept 2013, some from Jan 2013 to Dec 2013, i.e the MonthYear varies from slider to slider. How do i acheive it ? I tried to create variable and acheive it. But i'm not getting the right way to do it. Can someone help me out!

Regards,

Padmanabhan

[tresesco]

Please post your sample app.

[#3]

Hi tresesco,

Pls find attached the sample app. Thanks for your help.

[#4]

Hi

use an expression instead of fieldname

something like  if(month >= 201201, month)

best regard

Chris

[jagan · Accepted solution]

Hi,

PFA file for solution.

Regards,

Jagan.

[tresesco]

May be like attached sample. One suggestion, it's always better to create a MonthYear field in the script using MonthName() function than just a string concatenation.

PFA