[AccessD] Putting Dates in Order

Gustav Brock gustav at cactus.dk
Sat Feb 8 09:08:00 CST 2003


Hi Hollis,Virginia

> Is there anyway to get dates in order?
 
> I try Ascending & get:
 
> 01/01/2001
> 01/01/2003
> 02/01/2001
 
> I want:
> 01/01/2001
> 02/01/2001
> 01/01/2003
 
Those are text strings.
Wrap them in CDate() and sort on that.

/gustav




More information about the AccessD mailing list