Applying Time-Based Record Selection

You can select records based on a Date or DateTime field. You may want to see all the sales reps that have placed five or more orders in the past month.

To do this, you would create a record selection using the appropriate date and, if needed, formula fields in the Select Expert.

If you need a report that shows each staff member that had been hired between a certain time period. The easiest method is to use the "is between" option in the Select Expert.

Hint

Watch out for "is between" and "is less than" when entering dates. If no time is entered, the program assumes you meant "midnight" and you might miss an entire day’s results.

You could also use "is in the period" or "is not in the period." This method provides you with options to select a predetermined start and finish date for the period of time you request based on the computer system clock.

Use the Set Print Date and Time dialog box to set the date for your report. You can choose either today's date or specify another date.

This dialog box appears when you choose the Set Print Date and Time command from the Report menu.