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

Last updated