>I have a table that has several date fields. I have a SQL Query that does ORDER BY on one of date fields in table. The BROWSE window is NOT showing a properly sorted recordset sorted on this ORDER BY (date). Why?
>
>TABLE: Lar_sum
>Field: rcvdte (Date)
>
>Here is what comes out of SQL Query:
>
>SELECT rcvdte from lar_sum ;
> WHERE rcvdte < DTOT({^1996-01-01}) ;
> AND !EMPTY(rcvdte) ORDER BY rcvdte ASC
>
>11/13/01
>10/06/99
>10/12/99
>04/12/79
>08/02/83
>
>...
>...
>
>What is going on here?
>
>Fz

Donald,
Question: Why are you converting to datetime to check on date ?

SELECT rcvdte from lar_sum ;
   WHERE rcvdte < {^1996-01-01} ;
   AND rcvdte # {} ;
   ORDER BY rcvdte ASC

Converting to datetime wouldn't have a negative impact though.

Set century on

and retest. Those results might be from very old years like 1801, 1601...
Cetin