Calculates the difference between two date \ time \ datetime based on the date or time part requested

DateDiff("2021-01-01 22:00:00.000", "2022-01-06 11:00:00.000", DateValueOption.QUARTER) → 4
DateDiff(column1, column2, DateValueOption.DAY) → 7


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