Date

[#1]

Hi all,

I have a field named 'date' in excel sheet which contains 'month-year' data. e.g. Nov-13

I am using this field as dimension axis for a particular graph and the problem is that it doesnt show in Nov-13 format , rather it shows as 1/11/13. How do i change it???

In the same field, for year i have values like 12,13,14 .

Now i need that dimension axis to be sorted as Jan-12, Feb-12....Dec-12,Jan-13,Feb-13......Dec-13,Jan-14,Feb-14...Dec-14

Please let me know the solution

Thanks in advance

[its_anandrjs · Accepted solution]

Format your date field in the load script like

Load

MonthName(date) as Datefield, //First Way

date#( date,'MMM-YY') as date  //Second Way

From Location;

[#3]

Thanx Anand.

Can u also help with sorting order

[its_anandrjs]

Yes tell me what type of Sort Order.

[#5]

its their in above post

[ashfaq_haseeb]

Hi

if you use

MonthName(YourDate) as MonthYear

Then you will have the desired sort you are looking at.

Regards

ASHFAQ