Re: date/time issue - daylight saving

[Thomas Bean]

** This is most likely an issue with the client's regional date/time settings (time zone and/or daylight saving time adjustment).   Are you observing the before and after "Rent From" times from the same client?  What time zone is the client set to?  Is it set to automatically adjust for daylight saving time changes?   Try querying the database for the record in question, before and after the update.  Does the integer value in the date/time field change?   ----- Original Message ----- From: ahaha hehehe Newsgroups: gmane.comp.crm.arsystem.general Sent: Monday, August 14, 2006 00:09 Subject: date/time issue - daylight saving   Hi Guys,        We've got some issues where "occasionally" the date decides to change   itself on certain records.   I'm still trying to trap the exact cause, but it's something like this:     We have a rent record which records your rent due with a from date and   to date (when this rate's applicable)     Every now and again, we get this happening:     Rent From was 1/4/05.     Record is updated (NOT the date however)   Now date is 31/3/05 (looking closer, it's stored as 31/3/05 11:00pm)      We got lots of this when Daylight saving is in effect.      Please advise.      Thanks!        --------------------------------- How low will we go? Check out Yahoo! Messenger's low  PC-to-Phone call rates. __20060125_______________________This posting was submitted with HTML in it___