Adds days [days]
to a date [date]
that can count forwards or backwards on a calendar.
Syntax
offset_days(date(year, month, day), days)
Parameters
-
datecan be any of the following:- Another function that returns a date.
- A formula column that returns a date.
-
year: 4 digits.
For example, 2012 -
month: 2 digits.
For example, 01 or 12 -
day: 2 digits.
For example, 01 or 30 -
days:- Positive number: Counting forward
- Negative number: Counting backwards
Examples
-
offset_days(today(), 7): If today is October 24, 2016, the function returns October 31, 2016. -
offset_days(date(2016,10,31), -7): Returns October 24, 2016.
