> Here's what Google tells me regarding days between "now()" and a > database > column value. > > select extract(day from (sysdate - dte_2dlcl)) > > I have no idea if that's correct and can't test. I think it's a step > in the > right direction. > > Here's the reference: > http://stackoverflow. com/questions/1> 646001/how-can-i-get-the-number-of-days-between-2-dates-in-oracle-11g > Michael, select extract(day from (sysdate - dte_2dlcl)) if run in sql plus or toad but not from with <cfquery>
However, this works: ORACLE: <cfquery name="final2" datasource="dev11g" > select corr_id, CAST(dte_2dlcl - #today# as integer) as draft, CAST( dte_final - #today# as integer) as final from EXECCORESP000 </cfquery> The result: draft = 0, final = 3 which is correct as dte_2dlcl= 1/14/11 and dte_final = 1/17/11 CF <cfquery name="final" datasource="dev11g" > select c.* from EXECCORESP000 c </cfquery> <br /> <cfset today = #Now()#> <cfset draft =dateDiff('d',#today#,#final.dte_final#)> This also provides the correct value. Thanks for you input. JB ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm