> 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:280628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
