How to add days, months, or years to a date?

You can use the ADD function to add days, months or years to a date. The add function can be used with an input date field or a calculated date field.

Add days to a date

ADD function

You can add days to a date by specifying "days" as the term in the ADD function.

Syntax:
add(number_of_days, "days")

Example usage:
TODAY().add(30,"days")
Inputdate.add(5,"days")

Add months to a date

You can add months to a date by specifying "months" as the term in the ADD function.

Syntax:
add(number_of_months, "months")

Example usage:
TODAY().add(6,"months")
Inputdate.add(3,"months")

Add years to a date

You can add years to a date by specifying "years" as the term in the ADD function.

Syntax:
add(number_of_years, "years")

Example usage:
TODAY().add(1,"years")
Inputdate.add(2,"years")