Nope. We have sorted it - sort of. It is Microsoft's fault. It is the same problem we've all mentioned. It appears that even when the locale is changed, the registry setting is still set to SHORTDATE=M/D/YYYY.
We have simply changed the registry so that the SHORTDATE=D/M/YYYY and now datetime ignores locale - hey presto! However, it does appear that CF occasionally changes which user it uses to access local settings. As a precaution we have changed all users on the system so that SHORTDATE is correct. If anyone has this problem and wants to know the location of the registry key then let me know. Paolo PS CF is partially off the hook, although it's "random" use of settings and it's tendency to interpret dates "intelligently" can be a pain. -----Original Message----- From: Taz -=TT=- [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 10:01 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CF5 setlocale bug > Except we are getting the problem with dateformats and not currency. Our > problem is that when the system is rebooted, dates passed to an object are > sent as mm/dd/yyyy (no matter what you tell it to do) - this screws up the > object. When CF is restarted on the server, it reverts to dd/mm/yyyy!! Are you wrapping your dates in an LSParseDateTime()? In my experience it is always necessary to stick an LSParseDateTime on a eurodate before entering it into the database... that's on any OS, any version of CF and any database. Taz -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
