Using Dynamic Date Values in the Job Execution Wizard

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Summary

The Job Execution Wizard supports dynamic date values for Date Time Picker parameters. Users can select either a specific date or a dynamic date value directly within the wizard, simplifying the configuration of scheduled jobs that rely on changing date ranges.

Dynamic date values help reduce manual maintenance and make it easier to create schedules that automatically adjust over time.

What Are Dynamic Date Values?

Dynamic date values allow scheduled jobs to automatically resolve dates when an execution runs. Unlike static dates, dynamic date values adjust over time and do not require manual updates.

For example, a scheduled job configured with @Date will always use the current date when the job executes, while @FirstDayThisMonth automatically resolves to the first day of the current month.

Dynamic date values can be selected directly within the Job Execution Wizard, making it easier to configure scheduled executions that rely on changing date ranges.

Accessing Dynamic Date Values

To use a dynamic date value:

1. Open Scheduler.
2. Select a Job.
3. Click Add (Wizard) or Edit (Wizard) within the Executions section.
4. Navigate to a Date Time Picker parameter.
5. Select either:
   • A specific date
   • A dynamic date value

Available Dynamic Date Values

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

Common examples include:

Additional dynamic date values are available within the selector.

Benefits of Dynamic Date Values

Using dynamic date values can help:

• Eliminate manual date updates.
• Simplify scheduled job configuration.
• Create self-maintaining schedules.
• Support rolling reporting periods.
• Automate month-end and period-based reporting.

Common Use Cases

Daily Reports

Use @Date to automatically run reports using the current date when the job executes.

Month-End Reporting

Use values such as @FirstDayThisMonth or @LastDayThisMonth to automatically define reporting periods.

Rolling Date Ranges

Use relative date values to continuously adjust reporting windows without modifying scheduled jobs.

Historical Comparisons

Use relative week, month, quarter, or year values to automate historical reporting and trend analysis.

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.

Article Summary

The Job Execution Wizard supports dynamic date values for Date Time Picker parameters, allowing users to select dynamic dates directly within the wizard. This simplifies scheduled job configuration, reduces manual maintenance, and helps create schedules that automatically adjust over time.