Just a guess, but Guernsey is about 7 hours in the future (HMS in is EST time zone). That means that entries during 7 hours of the day would be a day behind. You will need to account for this and add a day during those 7 hours only.
HTH, -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert Les Mizzell wrote: > No hair left... > > Recap: > > 1. Main website hosted in Guernsey - (small island off the coast > of France). > > 2. Using webservices to read/write to a HostMySite database > in the US > > 3. Couple of forms with date entry (three fields day, month, year) > and then using createdate to put them together before saving. > > > When dates are entered into the Guernsey forms, they're getting > transformed before being saved: > > 04/20/1965 becomes 04/19/1965 > > It doesn't do it *all* the time - only *most* of the time. I discovered > this after writing a function to take the dates and *add* a day before > saving - which then saved as what was entered into the form. Except, > something it saves as the correct date, and sometime one day in the future. > > I can find NOTHING to cause this - except it *has* to do with the time > difference between Guernsey and wherever the HostMySite server is. I say > *has to*, because I simply can't think of anything else. > > Since I don't know why it's happening, have ZERO ideas for a solution. > > Anybody? Help! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
