Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi:
Formatted dimension:
Num(YourDate,’YourFormat’) -------????will work???
Or
Aggr(Num(YourDate,’YourFormat’), YourDate)
Or
Aggr(weekday (YourDate) &',' & day(YourDate), YourDate)
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
The =Weekday(DateField) &' '&Day(DateField) worked thanks for your help.