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. [week, day, hour, minute, second]

Output

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

Last updated

Was this helpful?