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

Last updated