Hello Larry. Let me see if i understand you.
I have Transdate1 = 31\10\2008 And Transdate2 = 01\08\2008 You want to know how many days are between the dates??? If the answer is yes, and you want the difference. The only thing that you have to do is declare a Int variable. And assing the value of the operacion like this: int numOfDays = transdate1 - transdate2; And that's all. If this is not the answer just let me know and i will help you. Gustavo Adolfo Camargo Téllez Microsoft Dynamics AX Developer MDO Consultores Asociados S.A. Bogotá D.C. - Colombia (South America) --- In [email protected], "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; >
