How do you change the format of the Dimensions in a chart?

[#1]

I know that I can change the format of the expression but I'm not sure how to change the format of the dimension. It is in a date format. At the moment it is like 01/01/01 but I would like to change it so that it looks like Mon 1.

Thanks

[christian77]

Hi:

Formatted dimension:

Num(YourDate,’YourFormat’) -------????will work???

Or

Aggr(Num(YourDate,’YourFormat’), YourDate)

Or

Aggr(weekday (YourDate) &',' & day(YourDate), YourDate) 

[MayilVahanan · Accepted solution]

HI

Try like this

=Weekday(date#('01/01/2012','DD/MM/YYYY'))& ' '&day(date#('01/01/2012','DD/MM/YYYY'))

or

=Weekday(DateField) &' '&Day(DateField)

if date format is in correct format..

Hope it helps

or

load in sxcript like that .ex:

Load *, weekday(Datefield)&''&Day(Datefield) as WeekDayField from tablename;

Then use that in chart as dimension

[#4]

The =Weekday(DateField) &' '&Day(DateField) worked thanks for your help.