When you saving the dates use UAT date time, this way it is always going to be the same for all time zones.
Thank you David Faynzilberg Software Developer/Analyst TRX 2970 Clairmont Road NE, Ste. 300 Atlanta, Georgia 30329 USA Office: 404 417-7135 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dale Bronk Sent: Friday, August 07, 2009 11:59 AM To: [email protected] Subject: [AFFUG Discuss] Dates This may be a dumb question, but I'm stuck so I need to ask. I'm have a tough time with dates. A customer in California enters a DOB of 2/5/1985 and saves (AMF app using Granite) which goes into the db with actual data of 2-5-1985 00:00:00. Now a customer in Georgia opens the same record and the DOB is 2/4/1985. I understand that the timezones on the clients are different. I'm looking for any advice on solving this without storing as text. Thanks, Dale ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
