K
KantFigureItOut
Hello All,
I am needing help. I am wanting to enter a Date of Birth and know what age a
person is on a certain date, let's say August 1st of the current year. Does
anyone out there know how to do this. The expression I am currently using is
something like this:
Expr4: DateDiff("yyyy", BirthDate ,(08/01/2005)) + CInt(Format(BirthDate,
"MMDD") > FORMAT((08/01/2005),"MMDD"))
BirthDate is the Field Name used in my table for their Date of Birth
The (08/01/2005) is me not knowing what I am doing. Any help out there would
be greatly appreciated.
Thanks Everyone, Jeff
I am needing help. I am wanting to enter a Date of Birth and know what age a
person is on a certain date, let's say August 1st of the current year. Does
anyone out there know how to do this. The expression I am currently using is
something like this:
Expr4: DateDiff("yyyy", BirthDate ,(08/01/2005)) + CInt(Format(BirthDate,
"MMDD") > FORMAT((08/01/2005),"MMDD"))
BirthDate is the Field Name used in my table for their Date of Birth
The (08/01/2005) is me not knowing what I am doing. Any help out there would
be greatly appreciated.
Thanks Everyone, Jeff