Hi, try this method to calculate the date difference intvNo(columDate, offsetDate, IntvScale::WeekDay)
-- Regards Deepankar http://axgeek.blogspot.com/ On Wed, Dec 3, 2008 at 7:07 PM, larrybellou <[email protected]> wrote: > 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; > > > [Non-text portions of this message have been removed]
