Both the server and workstation are in the CST timezone/North America.
________________________________ From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Andriy Panas Sent: Sunday, June 27, 2010 3:43 PM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Working with date/Time in FB What is timezone value at the client? If you are at one of the region "On Windows XP the behavior can be reproduced with: Beirut (Lebanon) Brasilia (Brasil) Buenos Aires (Argentina) Amman (Jordany) Cairo (Egypt) Manaus (Brasil) Santiago (Chile)" .... then wait for the winter for DST time to be gone =) Flash Player <https://bugs.adobe.com/jira/browse/FP> <https://bugs.adobe.com/jira/images/icons/link_out_bot.gif> Date class Bug https://bugs.adobe.com/jira/browse/FP-1760 <https://bugs.adobe.com/jira/browse/FP-1760> <https://bugs.adobe.com/jira/browse/FP-1760> -- Best regards, Andriy Panas On 27 June 2010 23:22, Smin Rana <sminr...@gmail.com <mailto:sminr...@gmail.com> > wrote: You are getting data as xml from cf, so everthing should be fine. if you return A you should get A. now it looks like thing is very interesting, cant you help you in this case, again debug the code and take a look of the network monitor Of FB. -----Original Message----- From: Scott Sent: 06-28-2010 03:27:00 Subject: RE: [flexcoders] Working with date/Time in FB I just verified both server and client are at the same time and same timezone. I wasn't doing anything special with the object I was returning initially when it was giving me the wrong time. I literally assigned the dataGrid to the CFobject that was being passed. <mx:DataGrid x="68" y="446" id="dataGrid" dataProvider="{getAlltblreservationResult.lastResult}" visible="false"> <mx:columns> <mx:DataGridColumn headerText="pkReservationID" dataField="pkReservationID"/> <mx:DataGridColumn headerText="fkPilotID" dataField="fkPilotID"/> <mx:DataGridColumn headerText="fkPlaneID" dataField="fkPlaneID"/> <mx:DataGridColumn headerText="szSourceAirport" dataField="szSourceAirport"/> <mx:DataGridColumn headerText="szDestAirport" dataField="szDestAirport"/> <mx:DataGridColumn headerText="dtStart" dataField="dtStart"/> <mx:DataGridColumn headerText="dtEnd" dataField="dtEnd"/> <mx:DataGridColumn headerText="szSpecialRequests" dataField="szSpecialRequests"/> <mx:DataGridColumn headerText="pkPilotID" dataField="pkPilotID"/> <mx:DataGridColumn headerText="szPilotLastName" dataField="szPilotLastName"/> <mx:DataGridColumn headerText="szDescription" dataField="szDescription"/> <mx:DataGridColumn headerText="szPilotFirstName" dataField="szPilotFirstName"/> </mx:columns> </mx:DataGrid> Both dtStart and dtEnd were exactly one hour ahead of where they should be when I made the CF call. ________________________________ From: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> [mailto:flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> ] On Behalf Of Smin Rana Sent: Sunday, June 27, 2010 7:30 AM To: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> Subject: RE: [flexcoders] Working with date/Time in FB Are you sure server and FB got same timezone? I think you got some problem with your manipulation of before you set it to datagrid can you show the code where you set date on datagrid? Response date as a string from cf and set it on datagrid without any formatting? -----Original Message----- From: Scott Sent: 06-27-2010 19:19:40 Subject: [flexcoders] Working with date/Time in FB There's something I'm not completely understanding yet. I've coded around it but I'm not feeling comfortable with my solution. My FB4 app links up with CF9 and I'm working with dates and times. When I pull up a date from CF9 into a FB4 datagrid the time shows off by one hour. Eg. 2010-06-01 23:30:00 is in my MySQL DB (11:30pm). When I load the time from CF9 to a FB4 dataGrid it shows 2010-06-02 as the date and 12:30:00 as the time so the day advances because the time is one hour ahead. My initial thought is that it's something to do with either the timezone or day light savings time. Right now I just set a variable that I call DST, set it to -1 and then subtract it from the date before I manipulate the date and time. Even getting the UTC date/time then using the timezone still gets it off one hour without accounting for DST (that's why I think I'm dealing with daylight savings time) Can anyone confirm this or shed any light on what is going on? I don't want FB to worry about date and time; I want to do all of this through CF9 on the server side. I don't want to worry if the user has their computer set correctly for their timezone and daylight savings time. I just want FB to display the time it pulls directly from the CF9 object I provide it. Thanks a ton. sj -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/ <http://www.mailscanner.info/> > , and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean.