All eazyBI for Jira eazyBI for Confluence Private eazyBI


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


DateSerial(year, month, day)


yearInteger expression for year.
monthInteger expression for month.
dayInteger expression for day of month.


  1. DateSerial(2020, 12, 31) 
  2. Following is an example of 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()) - 2,-6) returns 7 days before the end of the 2 months ago to include a week where months does 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.