I am trying to take a birthday and entry date into our program and find out
the month. For example

Jane doe birthday is 11/1/08 and she enrolled 6/1/09. how do i find the age
in months at the time she enrolled?? what would be my formula? I have tried
several but I think I am missing a piece to it.

=DateDiff("m", [DOB], [EnrollDate]) - IIf(Format([EnrollDate], "dd") <
Format([DOB], "dd"), 1, 0)

DateDiff works by reporting "boundary crossings". If DOB is 31 May, 2009 and
EnrollDate is 1 June, 2009, that will be treated as 1, since you crossed
from one month to another. By comparing the days, you can reduce that count
by one unless a full month has transpired.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"MKoonce" <(E-Mail Removed)> wrote in message
news:75A8182A-0C4B-4CCE-8F25-(E-Mail Removed)...
>I am trying to take a birthday and entry date into our program and find out
> the month. For example
>
> Jane doe birthday is 11/1/08 and she enrolled 6/1/09. how do i find the
> age
> in months at the time she enrolled?? what would be my formula? I have
> tried
> several but I think I am missing a piece to it.