User's Manual

DPCTrack2
Users Manual
21-8
Figure 21.5
21.1.2.5 Using Date Field Key Words
You also have the ability to use date field key words in advanced queries. Date field key
words like “End of week”, “End of month”, “End of year”, “Today” and “Tomorrow” are
useful for queries involving dates, that may be used on a regular basis. Using this
functionality, you could build an advanced query to show all instruments that are due for
calibration by the “End of month” date, then save and execute it on a monthly basis.
Using the “End of month” date field key word instructs the system to always substitute
the last day of the current month into the selection criteria. To do this you would perform
the following steps:
1. Select Next Cal Date from the Selection Field Name drop-down list.
2. Choose “< =” from the Operation drop-down list.
3. Choose “End of month” from the Selection Value field’s drop-down list.
4. Finally, click the Add To Selection Criteria
button to move it into the Selection
Criteria During Query Execution box. Your screen will look like the one shown in
Figure 21.6 below.
5. Click the Execute
button to generate a query list showing all instruments due for
calibration by the end of the current month.