offset_days

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

  • date can 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.

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
10513870789188451733
true
Search Help Center
true
true
true
true
true
5055977
false
false