Calendar examples

Each of the these examples assumes that the Calendar Editor is up and running.

Example: Mondays, except on holidays

  1. Ensure you have a calendar that repeats every Monday. Typically, that is the system calendar Mondays@Sys.

  2. Ensure you have a calendar called ‘Holidays’ that defines all of the non-working holidays for your company. Typically, that is the system calendar Holidays@Sys.

  3. From the Calendar menu, select New Calendar, then choose Combine Calendars.

  4. Define a combining expression that specifies ‘mondays’ but not ‘holidays’ as follows:

    Mondays@Sys Not in common with Holidays@Sys

    Do this by double-clicking on Mondays@Sys, then double-click on Not in common with, and then Holidays@Sys.

    Tip:

    To see the operators, you may need to drag the operator window over from the very right-hand side of the main window.

  5. Provide a meaningful description for the calendar, and save it with a unique name, such as ‘workingmondays’.

Example: every second Friday

  1. From the Calendar menu, select New Calendar, then choose Specify Pattern.

  2. Click Weekly.

  3. In the Every n weeks field, specify 2.

  4. Ensure The following days is selected, and click FRI, as follows:

  5. Provide a meaningful description for the calendar, and save it with a unique name, such as ‘oddfridays’.

Example: last working Friday of month

  1. Ensure you have a calendar that defines working days. Typically, that is the system calendar businessdays@Sys.

  2. Create a calendar called last_friday_of_month, similar to the system calendar first_friday_of_month@Sys.

  3. From the Calendar menu, select New Calendar, then choose Combine Calendars.

  4. Define a combining expression that specifies last_friday_of_month and the days it has in common with businessdays@Sys as follows:

    last_friday_of_month@user In common with businessdays@Sys

    Do this by double-clicking on last_friday_of_month, then double-click on In common with, and then businessdays@Sys.

    Tip:

    To see the operators, you may need to drag the operator window over from the very right-hand side of the main window.

  5. Provide a meaningful description for the calendar, and save it with a unique name, such as ‘lastworkingfriday’.