How to get months names along with years in slider object box...?

[manozpph]

Guys, can you help me to get month names in slider object like Jan,Feb,mar.....,along with years in slider.

I took year as field in slider and tried to apply month names as variable but,month names not showing in variable box under year field.

I got months in number format and not in text format.Here I want text format  appearing  with years.

Thanks in Advance.....!

[jagan]

Hi,

Please find attached file for solution.

Script:

Data:

LOAD Date(Date) AS Date,

MonthName(Date) AS MonthName

INLINE [  

    Date

    1/1/2014

    2/1/2014

    3/1/2014

    4/1/2014

    5/1/2014

    6/1/2014

    7/1/2014

    8/1/2014

    9/1/2014   

];

Now use MonthName as field in Slider object.

Regards,

Jagan.

[sujeetsingh]

You can use concatenated field with month and year too.

[ashfaq_haseeb]

Hi

use below

MonthName(YourDate) as YearMonth,

Regards

ASHFAQ

[johncahillhp]

My dates are in number format as well.

I use the Slider Object Properties Number settings.

- Override the Document Settings

- Select Date

- Change the Format Pattern to MMM-yyyy

John