"How does August 2011 equal January 2011?" The sentence before the question mark
On Fri, Aug 19, 2011 at 10:43 AM, Mo Lay <[email protected]> wrote: > >> 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:5488 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
