James Blaha wrote: > > Thanks a million! Does the date format have to be in the yyyy-mm-dd format?
It doesn't have to be. But you wrote "6/3/03", and I wouldn't know what date that is. I presume the "03" means 2003, but how about the rest? Is that March 6 or June 3? Do you know? Does the next developer know? Does the server know? Does the server know after it has had an upgrade? Don't take chances, use an unambiguous format. And yyyy-mm-dd (or yyyymmdd) has the added advantage that a text sort gives the same result as a date sort. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

