> What? i did not catch your question here ?
> 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:5486 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
