Check Day of Week

Check the day of the week on which a specified date falls.

Prior to using this command, place the parameters of the relevant date (day, month, and year) into variables. To ensure that the formatting of these date parameters is correct, see A NOTE ABOUT FORMATTING.

  1. Enter the names of the variables in which each of the individual date parameters is stored.

  2. Indicate the day(s) of the week for which you'd like to check. (For example, to determine if the specified date falls on a weekend, check the boxes for Saturday and Sunday.)

  3. Enter the name of the variable into which you'd like to place the result of the check. (The result will be either TRUE or FALSE, as applicable.)

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

Let's say you have a series of reports that must be run daily except on weekends. Before running the reports, use the check day of week command to ensure that the report date is not a Saturday or Sunday.