Jon, If you set a column as a DATE datatype, you can then use that in your ORDER BY clause to order your columns. The format of the date does not matter, as the date is stored in its own internal format. You should/can change the format of the date when you display it in your CF/ASP page. In CF, you should use the CreateODBCDate() function to format the date correctly when you add it into the database: INSERT INTO MyTable (MyCuurentDate) Values (#CreateODBCDate(Now())#) Hope that helps, Chris Evans chris at fuseware.com http://www.fuseware.com -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele Sent: Friday, June 29, 2001 9:45 PM To: TheList Evolt Subject: [thelist] SQL, MS Access - ORDER BY date Hi everyone, I was wondering what the technique was to order records from a database by date? I need to to order the records returned to a query through mysql. Here are some questions I had: 1) If the field type is date, and I have 'ORDER BY field_which_has_a_date_type' will it order it correctly...or does it matter what the format of the date is? 2) What is the standard format of entering dates into an MS Access database from an coldfusion/asp 3) Is it possible to store the date in any format (e.g. 29/6/2001 9:35, or June 29,2001 9:35, etc. etc.) and use a Convert to timestamp function on it? Or does the format of the date matter? I was wondering if I could convert the dates in the db to a timestamp number of use that to sort it. An ideas are welcome. Thank You, Jon. __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !