Calculate Date Range

Determine the number of days between 2 specified dates.

Each date parameter (day, month, year) must be stored in its own variable. Therefore, when using this command, you are working with a total of 6 variables – 3 variables for each of the 2 dates in the range.

To learn more about the correct formats for these variables, see A NOTE ABOUT FORMATTING.

  1. Enter the names of the variables in which each of the individual date parameters is stored for both the from date and to date

    • To prevent errors when the wizard is run, ensure that the values of the variables are within the listed ranges

      It's easy to check variable values as they would stand at any point during execution of the wizard by using the View Variable List command

  2. Indicate whether you'd like to count only working days within the range

    • If you have chosen to count only working days, provide the days that constitute a work week

  3. Enter the name of the variable into which you'd like to place the result

  4. Instruct the wizard how to handle any errors encountered. Read more about error handling.

EXAMPLE:

Let's say your insurance company offers a grace period to customers whose policies have lapsed due to non-payment, giving them the option to reinstate their policies if payment is made within 7 working days . You can use the calculate date range command to check whether payment was received during the 7-day grace period.