offset_months
function adds months to the month component of date, if the resulting month doesn't have enough days for the day component, the last day of the new month is returned.
Syntax
offset_months(date(year, month, day), months)
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, 2012month
: 2 digits.
For example, 01 or 12day
: 2 digits.
For example, 01 or 30months
:- Positive: Counts forward
- Negative: Counts backward
Examples
offset_months(date(2020,12, 25), 5)
returns May 25, 2021