Date Sorting

[GDX]

Right now people enter data into an access database and there is a field called Date_Entered its a date/time field, whats the best way to sort this date? In MSSQL i used to just make a varchar field i enter it as YYYYMMDD but in this database the are entering the dates as MM/DD/YYYY and sometimes M/DD/YYYY or M/D/YYYY.....Whats the best way to sort this field?

Thanks a lot,
Gordon

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[AlienRay]

The formatting of the dates should be irrelevant. The only question is: WHERE do you want to sort it? In a query? On a report? On a form?

 

[GDX]

In the query im looking for the best way to sort

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371