calculating between 2 dates

[indigo993]

I have created a fixed asset subledger which includes a purchase date and the
lifetime of the asset (in months). At the end of each month I would like to
calculate the age in months between the purchase date and the current month
end date and then calculate the remaining life of the asset.
For example - purchase date 02/25/2005 , month end date 09/28/2008,
lifetime of asset - 60 months.
How do I include incorporate the current month end date and the remainining
life of the asset into my query?

 

[KARL DEWEY]

Months_Remaining: DateDiff("m", [Purchase Date],
DateSerial(Year(Date()),Month(Date())+1,1)-1)