could there be a database trigger on the table that is manipulating the date?
This has happened to me - and it was only on the production server, not test and dev; that had me pulling my hair out!! On 6/11/07, Les Mizzell <[EMAIL PROTECTED]> wrote: > > > It sounds like maybe it's attempting to convert the time you entered to > a local time to the server. > > That was my first thought. BUT - right now (8:40 AM) it's 6/11/2007 both > here and there. I've run test all hours and it happens regardless. > Still, this *has* to have something to do with it, I just can't figure > out WHY. I've tested with dates in the past as well. Something on the > Guernsey server seems to be the cause, but jezz - what? > > > Is the web service doing anything with dateConvert()? > > Nothing at all. > > On the Guernsey side (simplified...): > <cfinvoke webservice="#request.cfcLOCATION#"...... > WSdepDATE="#form.depDATE#" ... > > > On the US side it's a simple "insert statement with the date handled > thusly: > <cfqueryparam cfsqltype="CF_SQL_DATE" value="#WSdepDATE#" /> > > That's it. > > Now, on the US side - it's also creating/recording the date the record > is inserted using now(), and *THAT* date is correct. Go figure... > > > Are you sure you're not supposed to be entering the date/times in GMT > format? > > I'm doing a calculation between two dates on the form, and the > calculation is coming out correct - the date just end up one day off. > > The only solution I can actually come up with was an earlier > tongue-and-cheeck "just post the dates a day in advance". > > Still, I'd like to know *why* it's happening exactly. I've never seen > anything like this before. > > Coffee - must have more coffee input..... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
