fbpx

dtWithDayOfMonth (MDX+)

Returns the member changing the current member's day of the month.

Parameters

Name Type Cardinality Default value
  member-expression  one   
day of the month [1-31]  numeric-expression  one   

Return

member

Description

This functions returns a member changing the current member's day of the month.

dtWithDayOfMonth( [Time].[Calendar].[Day].[6 Jun 2006], 5 ) will return the 5th of June
dtWithDayOfMonth( [Time].[Calendar].[Day].[6 Feb 2006], 31 ) will return the 28th of February that is the last day of the month.

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.