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

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)

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™.