Top Navigational Bar

How To Sort And Select Records From A Certain
DocumentID: 607919
Revision Date: 29-Feb-96 1:32:32 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Solutions: If you want to use the Sort feature to select all records that contain a specific date or later, use the following steps (Note: This will only work if the dates are in numerical format, e.g., 10/24/90 and not October 24, 1990):
1.      Enter the Sort menu (Ctrl-F9, 2) and select 3 for Keys. Define three keys: one for the year, one for the month, and one for the day. The keys must be defined in that order if you want it to sort by the date and also select the correct records.
2.      Define your select statement using the following logic and syntax: (((keymonth=month * keyday>=day) + keymonth>month) * keyyear=year) + keyyear>year

For example, if you want to select all records that are dated 10/24/90 and later, the sort menu should be defined as follows:

key 1 -- type n, field 1, line 1, word 3 (this is the year)
key 2 -- type n, field 1, line 1, word 1 (this is the month)
key 3 -- type n, field 1, line 1, word 2 (this is the day)
The select statement would be:
(((key2=10 * key3>=24) + key2>10) * key1=90) + key1>90

As an alternative, the user could just sort by date and then pick all the records from the desired point forward. This example eliminates the need to delete the unwanted records after sorting by date.

The following format allows you to select a specific range:

((((keymonth=begin_month * keyday>=begin_day) + keymonth>begin_month) *
keyyear=begin_year) + keyyear>begin_year) *
((((key_month=end_month * key_day<=end_day) + key_month keyyear=end_year) + keyyear

Answer:

Details:


Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.