offset_years

offset_years function adds years to the year component of date.

Syntax

offset_years(date(year, month, day), years)

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
  • years
    • Positive: Counts forward
    • Negative: Counts backward
    • Example

Example

offset_years(date(2020,12, 25), 5) = 2025-12-25

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
4493927985648810345
true
Search Help Center
true
true
true
true
true
5055977
false
false