Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
//note that if your data set has multiple date fields this formula may not work. Try date Attribute instead.


//specify dates and return values between them
dateInterval('1/01/2015', '1/15/2015', M_REVENUE)
 
//dynamically calculate dates and return values between them
startDate = date('actualMonth() - 12m')
endDate = date('actualMonth() + 2m - 1d')
dateIntervals = toString(startDate, 'd/mm/yyyy')
e = toString(endDate, 'd/mm/yyyy')

dateInterval(s, e, { M_REVENUE} ) 


withoutDateTime()

...