Using Dynamic Date Values in the Job Execution Wizard

The Job Execution Wizard supports dynamic date values for Date Time Picker parameters.

Instead of selecting a fixed date, you can use values such as @Date or @FirstDayThisMonth so the date is calculated when the Job runs.

This is useful for scheduled Jobs that use changing date ranges.

What are dynamic date values?

Dynamic date values automatically resolve to a date when the scheduled execution runs.

Unlike a fixed date, a dynamic date value changes based on the execution date.

For example:

@Date uses the current date.
@FirstDayThisMonth uses the first day of the current month.
@LastDayThisMonth uses the last day of the current month.

Use a dynamic date value

To configure a dynamic date value:

Open Scheduler.
Select a Job.
In the Executions section, select Add (Wizard) or Edit (Wizard).
Navigate to a Date Time Picker parameter.
Select either:
- A specific date
- A dynamic date value

Available dynamic date values

Dynamic date values are calculated when the scheduled execution runs.

Common examples include:

Value	Description
`@Date`	Current date
`@FirstDayThisMonth`	First day of the current month
`@LastDayThisMonth`	Last day of the current month
`@LastDayofLastMonth`	Last day of the previous month
`@XDaysAgo`	Date X days before execution
`@XDaysOut`	Date X days after execution
`@XMonthsAgoStartDate`	Beginning of a previous month
`@XMonthsOutEndDate`	End of a future month

Additional dynamic date values are available from the selector in the Job Execution Wizard.

Common use cases

Daily reports

Use @Date when the report should use the date on which the Job runs.

Month-end reporting

Use values such as @FirstDayThisMonth and @LastDayThisMonth to create date ranges that automatically adjust each month.

Rolling date ranges

Use relative values such as @XDaysAgo or @XDaysOut to create reporting periods that move automatically as the Job runs.

Historical reporting

Relative week, month, quarter, and year values can be used for scheduled reports that compare previous reporting periods.

Notes

Note: Dynamic date values are evaluated when the scheduled execution runs.

Note: The selected value is stored as a dynamic date value rather than being converted to a static date during wizard configuration.