Date Offset

Description

The Date Offset calculation offsets a date or a date/time by seconds, hours, days, weeks, months, quarters, or years.

Parameters

Options

Input Parameter Values	Input Values
Relative Offset	Numeric Value
Offset Unit	Year, Second, Quarter, Month, Week, Day, Hour, Minute (Required)
Only Rollup If	Generic Criteria

Input

Input	Input Values	Required
Input 1	Column or Date Literal	✔

Remarks

Used in Quick Calculations for corresponding data field type. A common use of this calculation is when creating Variables, where you want to take Today's Date and go back one month. The end result of the variable is then used as a filter for setting dynamically scheduled reports based on less than or equal to last month.

Example

User chooses to offset the invoice date by offset unit 'Weeks' and offset value of -2. The calculation will offset the invoice date by two weeks (prior).