Hi Claude, obviously there's some history to 'createODBCdate' and the function name says it all.
I was wondering - now CFMX uses JDBC is there any problems using createODBCdate with JDBC connections? Is there a better practice, alternative functions? Or does CF just handle it all? Cheers, AS -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, 25 January 2006 9:54 AM To: CF-Talk Subject: Re: Date Formats >>am sure I haven't had that problem with other databases thought. Actually, it depends on the date. If the date cannot be interpreted as a valid date in American format, CF will assume it is in European and convert it correctly. Problem arrises when the date format is ambiguous, like 10/12/2005. This date is valid in American format, and CF has no way, nor any reason to supose it could be in European format. So actually you will only have a problem for the first 12 days of any month, except the first of jan, the 2nd of feb, etc. AND somebody discovers something is wrong, which is not 100% of times ;-) -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54