DateDiff

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

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