🀄

3. Time Intelligence Functions

Status
Not started

Time Intelligence Functions

  • TOTALYTD, TOTALQTD, TOTALMTD
  • DATESYTD, DATESQTD, DATESMTD
  • SAMEPERIODLASTYEAR, PARALLELPERIOD, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
  • NEXTMONTH, NEXTQUARTER, NEXTYEAR
  • FIRSTDATE, LASTDATE, FIRSTNONBLANK, LASTNONBLANK, DATESBETWEEN, CLOSINGBALANCEYEAR, OPENINGBALANCEYEAR