I have a calculated field that is trying to figure out someones age by using
2 fields.
One field has the current date with a Long Date Format. The other field
holds a birthdate (also long date format). It looks like this:

=DateDiff("yyyy",[DOB],[Text41])

It kind of works but the problem is that if a persons birthdate is in
November and they are currently 25 years of age (now in May) - the
calculation spits out 26 before November actually arrives.

Can anybody help?

Try to look here:
http://www.mvps.org/access/datetime/date0001.htm

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Adam" <(E-Mail Removed)> wrote in message
news:834C22BE-7CC7-4271-9744-(E-Mail Removed)...
>I have a calculated field that is trying to figure out someones age by
>using
> 2 fields.
> One field has the current date with a Long Date Format. The other field
> holds a birthdate (also long date format). It looks like this:
>
> =DateDiff("yyyy",[DOB],[Text41])
>
> It kind of works but the problem is that if a persons birthdate is in
> November and they are currently 25 years of age (now in May) - the
> calculation spits out 26 before November actually arrives.
>
> Can anybody help?
>

Alex,

It's not working...I tried doing it as an Event Procedure on the Before
Update but no dice - I dont get an error but the field stays blank. Then i
tired it as an expression in the expression builder but had the same blank
result.????

"Alex Dybenko" wrote:

> Try to look here:
> http://www.mvps.org/access/datetime/date0001.htm
>
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
>
> "Adam" <(E-Mail Removed)> wrote in message
> news:834C22BE-7CC7-4271-9744-(E-Mail Removed)...
> >I have a calculated field that is trying to figure out someones age by
> >using
> > 2 fields.
> > One field has the current date with a Long Date Format. The other field
> > holds a birthdate (also long date format). It looks like this:
> >
> > =DateDiff("yyyy",[DOB],[Text41])
> >
> > It kind of works but the problem is that if a persons birthdate is in
> > November and they are currently 25 years of age (now in May) - the
> > calculation spits out 26 before November actually arrives.
> >
> > Can anybody help?
> >
>
>
>

Now I'm getting a negative one (-1) when i type it directly into the field.

Any other suggestions??

"Alex Dybenko" wrote:

> Try to look here:
> http://www.mvps.org/access/datetime/date0001.htm
>
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
>
> "Adam" <(E-Mail Removed)> wrote in message
> news:834C22BE-7CC7-4271-9744-(E-Mail Removed)...
> >I have a calculated field that is trying to figure out someones age by
> >using
> > 2 fields.
> > One field has the current date with a Long Date Format. The other field
> > holds a birthdate (also long date format). It looks like this:
> >
> > =DateDiff("yyyy",[DOB],[Text41])
> >
> > It kind of works but the problem is that if a persons birthdate is in
> > November and they are currently 25 years of age (now in May) - the
> > calculation spits out 26 before November actually arrives.
> >
> > Can anybody help?
> >
>
>
>

"Adam" wrote in message:
news:834C22BE-7CC7-4271-9744-(E-Mail Removed)...

> I have a calculated field that is trying to figure out someones age by using
> 2 fields.
> One field has the current date with a Long Date Format. The other field
> holds a birthdate (also long date format). It looks like this:
>
> =DateDiff("yyyy",[DOB],[Text41])
>
> It kind of works but the problem is that if a persons birthdate is in
> November and they are currently 25 years of age (now in May) - the
> calculation spits out 26 before November actually arrives.

Adam,

Create an unbound text box on the form called txtAge and set it
to be Locked and not Enabled.

Set the Control Source of this text box to this

=DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))

That's all you need.
--
Jeff Conrad
Access Junkie
Bend, Oregon