I hope someone here has run into this strange problem I am having. Using a remoting call to a ColdFusion web service, I am returning a recordset from my SQL database for use in my Flash application. One field in the recordset is a datetime field type returning a date in the format '2006-10-04 00:00:00.0' as an example. In my actionscript, I am parsing this value to format it for display:
Var datestring = dayArray[result.items[i]["date"].getDay()] + " " + monthArray[result.items[i][ "date"].getMonth()] + " " + result.items[i][ "date"].getDate() + "," + " " + result.items[i][ "date"].getFullYear() ****Where dayArray and monthArray are predefined**** This displays perfectly as 'Wednesday October 4, 2006'. However, we and our web and database server are on the east coast and we have recently found that users with computers set to Pacific Time are getting the date displayed 1 day earlier, 'Tuesday October 3, 2006'. I have replicated this by setting the timezone on my own computer to Pacific Time. I have also checked and double checked the web service return before it gets to the Flash application and it is definitely returning the correct dates. There should not be any time zone handling using these functions a it is just a simple value coming directly from the database field. Has anyone run into a date problem such as this? I am at a loss. Thanks in advance!! Kevin Bachman Senior Developer ActiveGroup 3720 DaVinci Court, Suite 100 Norcross, GA 30092 678.405.1197 www.activegroup.net _______________________________________________ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
