I would say its a localisation issue on the server _____
From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Tuesday, 8 June 2010 10:20 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005 @Steve: the date is created by the following, so it should be a coldfusion date object: <cfset thisdate = createdate( thisyear, thismonth, thisday ) /> <cfset ECRTTotal.setdateentered( thisdate ) /> @Blair, I think you're right - the difference is between dates less than or equal to 12th in the month, where the day value could be either month or day. But how to ensure that it always puts the day value in the correct place is the question I can't answer yet. @Peter, yes SQLServer is definitely ODBC compliant. In fact you have plenty of your own databases on this same box. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jun 8, 2010 at 9:55 AM, Peter Tilbrook <peter.tilbr...@gmail.com> wrote: SQL Server is not ODBC compliant? - -- -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.