Tuesday, February 21, 2012

retrieve either day of week or day name for current date

How can I code an mdx statement to return either the number for the current day of the week (ie. 1 - 7), or the name of the current day (Monday, Tuesday, etc.)? day(now()) gets me the actual calendar day

Thank you,

PB

Hopefully, this helps you get where you want to go:

Code Snippet

with member [Measures].[x] as

datepart("w",VBAMDX!Now())

select [x] on 0

from [Adventure Works]

;

B.

No comments:

Post a Comment