>there's createdate(), >there's <cfqueryparam cfsqltype="cf_sql_date" >And if you want to do it in Oracle there's the to_date(string) function. > > >> Thanks , i got it working with <cfqueryparam cfsqltype="cf_sql_date"> but still not converting correctly ..
Iam using <cfqueryparam value="FORM.M1" cfsqltype="cf_sql_date"> <cfqueryparam value="FORM.M6" cfsqltype="cf_sql_date"> where M1 = Aug-11 i.e (August/ 2011 ) and M6 = Jan-12 (January /2012) but what is actually entered is M1 = 08/11/2011 and M6=01/12/2011. and what i want is M1= 01/01/2011 (mm/dd/yyyy) and M6 = 12/01/2012 thoughts ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5484 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
