RE: [Junk E-Mail - LOW] RE: [flexcoders] Re: Date Bug?

[Shannon Hicks]

I had this EXACT same problem... but get this:   In flash, I use a datepicker. In CF, I use cfsql_date, and in mysql the column it's stored in is date.   So, timezones shouldn't matter, since I'm never dealing with time.   The data gets saved to the database as the incorrect date.   I asked the Flex guys at MAX, but the suggestions there didn't help. I'm in CST, and so far nobody else with the problem has been in the CST timezone.   Shan From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Battershall, Jeff Sent: Wednesday, November 01, 2006 4:26 PM To: flexcoders@yahoogroups.com Subject: [Junk E-Mail - LOW] RE: [flexcoders] Re: Date Bug? Doug, I did think of that - but the date issue was demonstrated at 11:00 AM PST/1:00 DST. I'm thinking that this behavior could be replicated pretty easily - we worked around it by passing simple strings as I said. Jeff -----Original Message----- From: [EMAIL PROTECTED]ups.com [mailto:[EMAIL PROTECTED]ups.com] On Behalf Of Doug Lowder Sent: Wednesday, November 01, 2006 3:57 PM To: [EMAIL PROTECTED]ups.com Subject: [flexcoders] Re: Date Bug? I'm doubtful this is a bug because of the fact that you are dealing with two timezones. The Date class converts times to client-local values based on the OS's timezone setting, so if the time in question is between 12:00 and 2:59 AM Eastern you will see a date of one day earlier when viewed in Pacific timezone. You can do some testing with date.toUTCString() to make sure dates/times are the same no matter what the client timezone is. Doug --- In [EMAIL PROTECTED]ups.com, "Battershall, Jeff" <jeff.battershall@...> wrote: > > Some interesting behavior turned up by populating a combox box with some > dates pulled from a CFQUERY-driven dataprovider and passing the selected > date back via post to a CF page. Certain users would consistently get > the date back one day earlier than was intended. Has anyone seen > anything like this? I'm on the East Coast and the user in question was > on the West Coast if that matters (and I don't think it should). > > What I've had to do is 'dumb it down' by passing a simple string > yyyyddmm and then parsing it on the CF side of things after the post > operation - something about date handling within Player 9 seems a little > quirky. In other words I eliminated all date parsing from remote object > back to Flex and Flex back to CF. > > Note that the user had the same exact behavior on IE or Firefox. Any > insight appreciated! > > Jeff Battershall > Application Architect > Dow Jones Indexes > jeff.battershall@... > (609) 520-5637 (p) > (484) 477-9900 (c) > -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Free Edition. __._,_.___ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___ -- No virus found in this outgoing message. Checked by AVG Free Edition.