DATEADD

Adds or subtracts a specific number of time steps from a date

DATEADD( start_date , time_step, time_unit)

Returns a date some number of time steps away from start_date

Arguments

Argument	Description
start date	Date/time value(s) corresponding to start date
time step	Number of time steps to add or subtract from start date
time unit	Unit of time step to add or subtract from start date. [year, month, week, day, hour, minute, second]

Output

New date offset from start date by some number of time steps.

Example