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
Thanks a lot,
Gordon
Gordon R. Durgha
gd@vslink.net