Display day of week names

[dougp]

It seems like there would be a function that produces day names or abbreviations, but I can't find it.  Is there a better way to do this?

Code Select Expand


case _day_of_week ([C].[namespace].[subject].[Date_], 1)
when 1 then 'Mon'
when 2 then 'Tue'
when 3 then 'Wed'
when 4 then 'Thu'
when 5 then 'Fri'
when 6 then 'Sat'
when 7 then 'Sun'
end


[MFGF]

It seems like there would be a function that produces day names or abbreviations, but I can't find it.  Is there a better way to do this?

Code Select Expand


case _day_of_week ([C].[namespace].[subject].[Date_], 1)
when 1 then 'Mon'
when 2 then 'Tue'
when 3 then 'Wed'
when 4 then 'Thu'
when 5 then 'Fri'
when 6 then 'Sat'
when 7 then 'Sun'
end


Hi Doug,

Can you just use formatting for this? Just use the full date, and use the data format property to suppress eras, years, months and days, and set the "Display weekdays" option to "Short name"

Is this an option for you?

Cheers!

MF.

[dougp]

It's for a chart that should show 7 data points.

[MFGF]

It's for a chart that should show 7 data points.

Ah, in that case, no dice. Your case statement is the best option.

Cheers!

MF.