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())
Issue created year
Use the following formula to get the year when the issue was created. It will work if the issue itself is present in the report or formula.
Year([Issue].CurrentHierarchyMember.GetDate('Created at'))
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)