dtWithYear (MDX+)

Returns the member changing the current member's year.

Parameters

Name	Type	Cardinality	Default value
	member-expression	one
year	numeric-expression	one

Return

member

Description

This functions returns a member changing the current member's year.

dtWithYear( [Time].[Calendar].[Day].[6 Jun 2006], 2007 ) will return the 6th of June 2007.

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

dtWithYear(member,numeric)

Returns the member defined by the parameter year of the member date

Query

dtWithYear([Calendar].[Day].[23 Jun 2016],2018)

Result

{ 
  [Calendar].[Calendar].[Day].&[2018-06-23]
}

Assertion : MDX Equals

[Calendar].[Day].[23 Jun 2018]

Assertion : MDX Equals

[Calendar].[Day].[23 Jun 2016].dtWithYear(2018)

dtWithYear(member,numeric) - month level

dtWithYear(member,numeric) - year level

Special Examples (errors, null, ...)

dtWithYear(NULL,numeric) - return NULL

dtWithYear(member,numeric) - member not a date time type

Since Version

6.0

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.