All eazyBI for Jira eazyBI for Confluence Private eazyBI


Returns date for a specified year, month, and day.


DateSerial(Year_Numeric_Expression, Month_Numeric_Expression, Day_Numeric_Expression)


Year_Numeric_ExpressionInteger expression for a year.
Month_Numeric_ExpressionInteger expression for a month.
Day_Numeric_ExpressionInteger expression for a day of the month.


DateSerial(2023, 12, 31)

The following example shows a calculated member in Time dimension Weekly hierarchy to get all full weeks from the last three months, including the current month: 

    DateSerial(Year(Now()), Month(Now())-2, -6),
    DateSerial(Year(Now()), Month(Now())+1, 0)

DateSerial(Year(Now()), Month(Now())-2, -6) returns 7 days before the end of the 2 months ago to include a week where months do not start with the first day of the week.
DateSerial(Year(Now()), Month(Now())+1, 0) returns the last day of the current month.

See report example Most active days by weeks and weekdays in our Demo account. The calculated member Last three months in dimension Time uses the formula above.  The report uses this calculated member and several others calculated members in Time dimensions as a selection option on Pages.