GC> The dates are formatted as dd-mm-yy (hyphens included). When using
the sort
GC> menu, I made sure to sort numerically. No matter how I try, the
dates
GC> always sort based *ONLY* on the first two characters, that is the
"dd"
GC> portion. This of course would be wonderful if all the dates were
in the
GC> same month and year but they are scattered over a four year period.
GC> I have tried using "keys" and identifying the "mm" and "yy" portions
as
GC> second and third words all to no avail. I also made sure that the
column
GC> indicator reflected the appropriate one. Other efforts have
included using
GC> search and replace to change the hyphens to "/" and also to spaces.
I have
GC> also messed about with the date format selection in table
definitions (albeit
GC> AFTER all data was input if that matters).
Using WordPerfect DOS 6.1, I just did it. I
replaced the hyphens with spaces, then sorted on three
keys, as third word, second word, first word. Field
was left at 1. It worked fine.
FIDO: Bill White @ 1:135/110 (Miami)
InterNet: bill.white@110.sunshine.com
* SLMR 2.1a * It would help if you would reduce your line width, please
--- Maximus 2.01wb
---------------
* Origin: Miami Amateur Computer Club BBS/USR Courier V.E (1:135/110)
|