Report Builder 2.0 MDX Date Parameter Format

The following Report Builder dataset parameter expression converts a Date to an MDX string:
 
="[Date].[Day].&[" + Format(CDate(Parameters!Date.Value), "s") + "]"
Advertisements