TIP: Click on subject to list as thread! ANSI
echo: wperfect
to: GARY CASSIDY
from: BILL WHITE
date: 1997-06-17 16:36:00
subject: Sorting a table by date

GC>  BW> Using WordPerfect DOS 6.1, I just did it.  I replaced the
GC>  BW> hyphens  with spaces, then sorted on three keys, as third word,
GC>  BW> second word,  first word.  Field was left at 1.  It worked
fine.
GC> Hmmm, I wonder if maybe having th ekeys in the reverse order changes
GC> anything?  Sounds like you have what I did with that exception (I
GC> used key 1  for word 1, key 2 for word 2 etc).
     OF COURSE!  It sorts on the first key first.  If
that's the day number, then the first sort in on the
day.  If two or more keys have the same day, then they
are sorted by key 2, which is the month.  Any that
still ambiguous are then sorted by key 3.
     You want to sort dd mm yy by year, then month,
then day, so key 1 must be word 3, key 2 = word 2 and
key 3 = word 1.  Now you've learned something about
sorting!
I hate this damn machine,
I wish that I could sell it:
It never does what I want,
Only what I tell it!
  FIDO: Bill White @ 1:135/110 (Miami)
 InterNet: bill.white@110.sunshine.com
 * SLMR 2.1a * Nasty comments go here!
--- Maximus 2.01wb
---------------
* Origin: Miami Amateur Computer Club BBS/USR Courier V.E (1:135/110)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.