Subtraction date to date and answer in Months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert mid month date to month end date 3
subtracting dates 6
Query Date Help 2
Difference in Date/Time 1
Pull Specific Data by Previous Month's Date (Date Entered via prom 1
Subtracting a fixed date from a date field 4
How do I subtract a date w/ time from a previous date with time 3
Trying to find previous (fiscal) month to date 2

Back
Top