View Single Post
  #3   Report Post  
Posted to microsoft.public.word.tables
Steve_Ray Steve_Ray is offline
external usenet poster
 
Posts: 24
Default How to get a correct 'date sort' -- 'year' priority, not 'mont

You didn't identify your word version.

The table sort feature allows you to specify your sort type as a date sort
(ascending/descending).


Thanks for your reply. This was a 'date sort' in WORD 97 in mm/yy format
(except that leading zeros were not used; i.e., January 2000 is not entered
as 01/00 but as 1/00).

Note that the problem is not that '00' (for 2000) is sorting before '98'
(for 1998).

The sort works okay on the first few years (1998-2001) but then seems to
stop prioritizing on the 'year' and starts prioritizing instead on the
'month' once it gets past a certain number of records.

It's been a while since I've done a date sort but I don't recall having had
this problem. There are about 350 entries (i.e., rows). Could it be that
the operation is failing because it doesn't have enough free memory to
complete the sort?