Year
Returns an integer containing a whole number representing the year.
Syntax
Year(Date_Expression)
Arguments
Date_Expression | MDX expression that returns a date value. |
|---|
Examples
Year from the current date
Get the year from the current date.
Year(Now())
Year from issue created date
Get the year from the issue property "Issue created date. " It will work if the issue itself is present in the report or formula.
Year([Measures].[Issue created date])
Year of the selected time period
This formula extracts the year number from the start date of the currently selected time period.
Year([Time].CurrentHierarchyMember.StartDate)