Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....!
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.
You can use concatenated field with month and year too.
Hi
use below
MonthName(YourDate) as YearMonth,
Regards
ASHFAQ
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