We will want to build a query to track these sales by the time the transaction occurred. We can then export the file to excel and remove the sales before or after your specified time frame.

Begin your query:
  1. Navigate to Analysis, then click on Information library
  2. Click Add an ad-hoc query
  3. Choose the source view of Sales Orders and click OK

Add fields to Include records where:
  1. In the left column, expand Sales Order Item, expand Sales Order Item Ticket, then select Program. From the middle column, drag Program Record into Include records where. Set Equal to your daily admission program.
  2. In the left column, select Sales Order. From the middle column, drag Order complete Date into Include records where. Set equal to the date you are looking to filter on.

Add fields to Results fields to display:
  1. In the left column, select Sales Order. In the middle column, drag Order complete date into Results fields to display. This field will display both the Date and the Time of completion in your query.
  2. Add any other criteria you would like to output to Results fields to display
  3. Click the Set sort and group options tab. Drag Order complete date into Sort records by

Save your query:
  1. Click Set save options
  2. Name your query
  3. Save and Close
  4. Export the query to CSV and delete any of the ticket sales times that do not fall into the time frame you are looking for.