use CreateDate(year, month, day) ==>
<cfset odbcdate = (Date: 2001-12-06 15:55:51)>
<cfset date = ListGetAt(odbcdate, 2, " "

>
<cfset newDate = CreateDate(ListGetAt(date, 1, "-"

, ListGetAt(date, 2, "-"

, ListGetAt(date, 3, "-"

)>
<cfoutput>#newDate#</cfoutput>
Sylvano
dsylvano@hotmail.com