Subtraction date to date and answer in Months

W

waheed Shahzad

Dear Sir

My problem is Subtraction of Date to Date and result i want in Months in
Ms.Access.
Let supose 05-June-2005 - 05-July-2006 and result (11 months). I want in
Query in Ms.Access. We will highly thankfull if you helpout in this matter.
 
D

Dennis

Surely the difference between those dates is 13 months and not 11 ?
Create a column in your query like this
DiffMonths: DateDiff("m",[FirstDate],[SecondDate])
 
Top