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