Calendar File Wizard

Calendar File Wizard

When using TsQuery, you can define your own set of dates, or you can select one of several predefined calendars. To create a custom calendar with only those dates of interest to you, select “Calendar File...” from the Tools menu.

Calendar Output File

In the Calendar File window, first specify a location to save the file. Type a path into the Output File text box, or click Browse... to navigate to the desired directory.

Date Range For Frequency

Next, define the custom calendar’s frequency and the date range for the frequency. In the Date Range for Frequency area, click the start date menu and select a date from the popup calendar.

Then either specify an end date in the same manner, or choose to end after a certain number of occurrences. “Occurrences” refers to the frequency you define in the Frequency area below. For example, say you define a weekly frequency recurring on Wednesdays, and choose to end after twelve occurrences. The query report will include data only from the twelve Wednesdays subsequent to the start date you specified.


With the date range in place, define the frequency of dates your query will access. In the Frequency area, select a frequency from the list at the left. If your query will use only individual dates with no regular interval, select None. You can then select those dates in the Custom Dates area below the Frequency area. If your query’s calendar will have some regular frequency, select one of the other options: Daily, Weekly, Monthly, or Yearly. When you select one, controls appear to the right allowing you to customize the frequency. Customization options are as follows.


Specify the frequency of days in the calendar, e.g., every day, every five days, etc.


Specify the frequency of weeks in your calendar, and select which days of the week will be included in a query report. For example, a calendar might include only the Monday and Friday of every third week between the start and end dates.


A monthly frequency provides two options. One is to select the frequency of months and specify which day of the month to include, for instance, the tenth day of every other month. The other also allows you specify the frequency of months, the type of day to include (e.g., Weekday, Weekend Day, or Thursday), and when that day occurs in the month (e.g., Third or Last). For example, a calendar might specify the second weekend day of every month, or the last Thursday of every third month.


The yearly frequency offers options similar to those of the monthly. A calendar might include March 3rd of every year, or the first weekend day in January of every year.

Custom Dates

In addition to, or in place of, a specified frequency, a calendar can include specific custom dates. To add specific dates, click the menu on the left in the Custom Dates area. Use the popup calendar control to find and select a date, and then click the Add Date button to add it to the list on the right. To remove a date from the list, click the Remove Date button.

When you are finished defining a custom calendar, click the Run button at the bottom of the Calendar File window to create the file. If you would like to view the generated file, click the View File button in the dialog box that appears. If not, click the Done button. The calendar file is now saved in the location you specified. To use your custom calendar with TsQuery, click on the Calendar File radio button on the Date tab, browse to the location of your calendar file, and enter the full path and filename. Other date options on this tab are superceded by the Calendar File option. To dismiss the Calendar File window, click the Close button.