How to calculate # of months past a date?

[djclinton15]

Hi. Is there any type of expression that will show me the # of months past a date?

I.E.
10/30/2016 – 4-months



Any advice/suggestions will be greatly appreciated! Thanks in advanced.

[pbaldy]

Check out the DateDiff() function.

[andy49]

Datediff sounds like it might be what you want.


Sent from my iPhone using Tapatalk

[djclinton15]

Thanks all for responding to my thread. I checked out several DateDiff websites & couldn't find what I'm looking for. Can any one suggest to me any DateDiff websites?

[andy49]

Datediff("mm", date, yourdate) returns months between now and yourdate


Sent from my iPhone using Tapatalk

[pbaldy]

https://www.techonthenet.com/access/...e/datediff.php

https://support.office.com/en-us/art...c-e24fc238f85f

[djclinton15]

Sorry, neither site helped me figure out what code/expression to retrieve the results as I illustrated above. I'm not a "programmer" & don't understand how to write out codes/expressions. This is why I came here for assistance the results I'm looking for. Not saying that you guys haven't been helpful; quite the contrary. I cannot express what admiration for those who volunteers their time (& wisdom) helping others with Access on this site. In today's world not many people volunteers ther time without a price. I think you guys are great!

I just get overly frustrated when I can't achieve what I set out for.

[andy49]

You say you need to say how many months it is after a date. Is the date in a table? A form?


Sent from my iPhone using Tapatalk

[pbaldy]

Both sites included examples. It would make more sense for you to posted what you're trying, and describe how it fails. You haven't even said how/where you're trying to use it.