Analysis Services
Mtd
Returns a set of members from the Month level in a Time dimension starting with the first period and ending with a specified member.
Syntax
Mtd([«Member»])
Remarks
The Mtd function is a shortcut function to the PeriodsToDate function that defines that function's «Level» argument to be Month. If no member is specified, the default is Time.CurrentMember.
Mtd(«Member») is equivalent to PeriodsToDate(Month, «Member»).
Example
The following example returns the first five days of September, 1997:
MTD([05-Sep-1997])