Setting Date Parameter Value to Reserved Word in the Scheduler

Use reserved words in a Scheduler execution to supply dates that change with each run, such as the first and last day of the previous month.

You can enter these values in either the Execution Job Wizard or Properties → Misc → Parameters. Both methods are available; you only need to use one.

Trouble viewing images? Right-click an image and select Open image in new tab to view the full-size version.

Before You Begin

Important: The View must already have the required parameter defined before that parameter can be added or edited in a Scheduler execution.

Open the View’s Parameters section to confirm that the date parameters exist and save the View before configuring the execution.

This example uses two Date Time Picker parameters:

Your parameter names and descriptions may differ.

The View already contains StartDate and EndDate parameters. The selected EndDate parameter is a Date Time Picker.

Demo Values: Previous Month

For a monthly report, use these values:

For a run in September 2026, these values represent August 1 and August 31, 2026. The dates change as the job runs in subsequent months.

Method 1: Use the Execution Job Wizard

1. Open the job in Scheduler.
2. Select the execution you want to update.
3. On the Job tab, click Edit (Wizard).
4. Continue through the wizard until you reach the parameter prompt page. In this example, it is Prompt Page 1.
5. Enter the reserved word in each date parameter field. You can also select an available reserved word from the field’s drop-down list.
6. For this demo, set Beginning Date to @FirstDayofLastMonth and Ending Date to @LastDayofLastMonth.

Both reserved words are entered directly on the wizard’s parameter prompt page.

7. Click Next and complete the remaining wizard steps.
8. Save the job.

Method 2: Use the Execution Properties

1. Open the job in Scheduler and select the execution you want to update.
2. In the properties panel, scroll to Misc.
3. Select Parameters (Collection) and click the … button to open the parameter editor.
4. Select the parameter you want to change.
5. Under Data, enter the reserved word in Value.

For this demo, select ?StartDate? and enter @FirstDayofLastMonth.

The parameter editor sets the selected parameter’s Value to a reserved word.

6. Select ?EndDate? and set its Value to @LastDayofLastMonth.
7. Repeat for any other date parameters that need dynamic values.
8. Click OK.
9. Save the job.

Verify the Results

Run the job and review the report to confirm that the parameters produce the intended reporting period.

For the previous-month example, a run in September 2026 should use August 1 through August 31, 2026 as its beginning and ending dates.

If a date parameter is missing from the execution, first confirm that it has been added to the correct View and that the View has been saved.

Related Articles

• Using Dynamic Date Values in the Job Execution Wizard
• Special Date Filtering Reserved Words in VDM