What? How does August 2011 equal January 2011? If that's not a type-o then use createodbcdate() http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000431.htm parse the date entered and create your own.
On Fri, Aug 19, 2011 at 10:33 AM, Mo Lay <[email protected]> wrote: > >>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:5485 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
