How can I figure out the difference in # of days between two dates?
Can it be done using a select statement as well?
The following t-sql is what I am trying to accomplish but if you can
answer one or both of the above questions would help me get there as
well..
T-SQL
select avg(datediff(day, transdate, closed)) from custtrans ct (nolock)
where accountnum='aa122'and closed > '1/1/1900' and dataareaid='demo'
and amountmst>0 and transdate >= getdate()-90
select custTrans where
localCustTrans.AccountNum=='ba368'
&& localCustTrans.Closed != datenull()
&& localCustTrans.AmountMST > 0
&& localCustTrans.TransDate >= systemdateget()-90;