days

Counts backwards the specified number of days starting from the most recent midnight. Partial days are not included. Can only be used as a duration parameter in for_date_range().

To count forward, eliminate the minus (-).

Syntax

  • days(-x) (counts backwards x days)
  • -days(x) (counts backwards x days)
  • days(x) (counts forward x days)

x is required to be an integer.

Examples

If you view a column with the following formula at 10 a.m. on October 15th, the function returns the number of clicks between October 1, 12:00 a.m. and October 14, 11:59 p.m.
Clicks.for_date_range(today(), days(-14))

The following formula returns the number of clicks between October 1, 12:00 a.m. and October 7, 11:59 p.m.:
Clicks.for_date_range(date(2013, 10, 01), days(7))

Was this helpful?
How can we improve it?