DateAdd

Adds the specified value for the specified date or time part to date \ time \ datetime

DateAdd("2021-01-04", 2, DateValueOption.MONTH) → 2021-03-04
DateAdd(column1, 7, DateValueOption.DAY) → 2023-02-06

Inputs

DateAdd(dateTime, value, datePart)

• dateTime - Date, time, or datetime value

• value - This is the number of units of time that you want to add

• datePart - This indicates the units of time that you want to add, ex. DateValueOption.DAY