dtWithMonthOfYear (MDX+)
Returns the member changing the current member's month of the year.
Parameters
Name | Type | Cardinality | Default value |
member-expression | one | ||
month of the year [1-12] | numeric-expression | one |
Return
member
Description
This functions returns a member changing the current member's month of the year.
dtWithMonthOfYear( [Time].[Calendar].[Day].[6 Jun 2006], 12 ) will return the 6th of December 2006.
See Also
dtNextWeek dtNextMonth dtNextQuarter dtNextYear dtPreviousDay dtPreviousWeek dtPreviousMonth dtPreviousQuarter dtPreviousYear dtPlusDays dtPlusWeeks dtPlusMonths dtPlusQuarters dtPlusYears dtMinusDays dtMinusWeeks dtMinusMonths dtMinusQuarters dtMinusYears dtFirstDayOfWeekOfMonth dtFirstDayOfWeekOfQuarter dtFirstDayOfWeekOfYear dtLastDayOfWeekOfMonth dtLastDayOfWeekOfQuarter dtLastDayOfWeekOfYear dtNthDayOfWeekOfMonth dtNthDayOfWeekOfQuarter dtNthDayOfWeekOfYear dtDatesWeek dtDatesWeekend dtDatesWorkweek dtDatesWtd dtDatesMtd dtDatesQtd dtDatesYtd dtDatesItd dtDatesWfd dtDatesMfd dtDatesQfd dtDatesYfd dtWithDayOfWeek dtWithDayOfMonth dtWithDayOfYear dtWithMonthOfYear dtWithYear dtWithTime
Examples
Special Examples (errors, null, ...)
Since Version
6.0
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.