With regards to the issue you describe, it certainly looks like a time zone issue that should be able to be sorted using a time zone offset being applied to the dates. Storing all dates relative to GMT is probably best.
Having said all that, I would be concerned that you may have a more serious underlying date/time issue that you will need to test given that you are having time zone issues, it's worth testing this second scenario too... The SQL server in the US is most likely to have its date format as mm/dd/yyyy and the CF server in Guernsey is most likely to have the date format of dd/mm/yyyy. The DB drivers can resolve this issue for dates over the 12th of the month 13/12/2008 and 12/13/2008 can only be one date but for dates up to the 12th of the month there can be issues... e.g. 07/12/2008 and 12/07/2008 could be two completely different dates or the same date depending on where you are in the world. To get around this second issue, you can either set your locales to the same *OR* do some sort of conversion before you send to the database or format the date in an unambiguous way e.g. dd/mmm/yyyy. Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:303391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
