My coworker just posted this over as the solution: http://www.macromedia.com/support/coldfusion/ts/documents/tn18324.htm
Mark On Wed, 14 Jul 2004 15:29:03 +1000, Barry Beattie <[EMAIL PROTECTED]> wrote: > > >> Any thoughts anyone? > > yeah, lots. > > the Jet db engine stores it's dates internally as mm/dd/yyyy, no matter > what the Access GUI is set to. > > BUT it will accept the ISO date format. See my posts on this last week. > http://www.cl.cam.ac.uk/~mgk25/iso-time.html > > see if you can send it dates in this format > > <cfset form.dateField = "04/05/2004"> > <cfset theDate = LSDateFormat(form.dateField, "yyyy-mm-dd")> > <cfoutput>#theDate#</cfoutput><br> > > ALSO, the Jet date delims are #'s (while SQLServer is ' ) > > where the date = #04/05/2004# > > which causes interesting problems with CF > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
