Luis, I already provided the tool from Paul.
In the link there is a download which contains some CFC for all possible methods etc.
Here is the one that Ryan is looking for and he can find on the URL that I provided.
castfromUTC return date in given timezone from UTC datetime. required argument thisDate, optional argument thisTZ valid timezone ID, defaults to server timezone.
<cffunction name="castFromUTC" output="No" access="public" returntype="date" hint="returns date in given TZ from given UTC date, takes DST into account, accurate to the second">
<cfargument name="thisDate" required="yes" type="date">
<cfargument name="thisTZ" required="no" default="#variables.timeZone.getDefault().getDisplayName()#">
<cfscript>
var tZ=variables.timeZone.getTimeZone(arguments.thisTZ);
var tYear=javacast("int",Year(arguments.thisDate));
var tMonth=javacast("int",month(arguments.thisDate)-1); //java months are 0 based
var tDay=javacast("int",Day(thisDate));
var tDOW=javacast("int",DayOfWeek(thisDate)); //day of week
var thisOffset=tZ.getOffset(1,tYear,tMonth,tDay,tDOW,0)/1000;
return dateAdd("s",thisOffset,arguments.thisDate);
</cfscript>
</cffunction>
Ryan,
Please try to check the solution on
http://www.sustainablegis.com/projects/tz/testTZCFC.cfm link.
Sincerely,
Oğuz Demirkapı