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


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