I would suggest that your code where you put it into the database is wrong then.
When you generate the date you are getting it back to front. ColdFusion assumes USA, but if that isn't valid will swap it. So if you say 15/01/2010 You get 15th Jan 10/01/2010 You get 1st October Regards Dale Fraser http://dale.fraser.id.au http://cfmldocs.com <http://cfmldocs.com/> http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Mike Kear Sent: Tuesday, 8 June 2010 12:18 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005 @Kym: you make an excellent point. I normally look at data in a table by running a query, so i'm looking at query results in Management Studio. So i used the Open table and looked at the data that way, and still see the same effect. I have dates in the table showing as 23/05/2010 12:00:00 AM and 5/02/2010 12:00:00 AM when they should all show as being in May. Also if i run a query on the table in coldfusion and cfdump the results, i see the same results. @Dale, thanks for your input. I also have 18 other databases on this server, and don't have this problem with them, and I usually use either createodbcdate() or <cfqueryparam with a type of CF_SQL_TIMESTAMP or CF_SQL_DATE. However in this case I have about 300 files of historical code that has worked fine on a server at fasthit and now i have it on my server it's giving this result. Re-writing the whole application is not a reasonable option, because the client's not going to pay me to re-write his existing code, no matter how much I'd like to. The code is legacy, dating back to CF5 for the most part and i would dearly love to see it modernised for a lot of reasons. But that is going to have to wait. 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 11:19 AM, Steve Onnis <st...@cfcentral.com.au> wrote: 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 -- 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.