In my access table I have Date of Birth (DOB) and Date Of Evaluation (DOE). How do I write a formula to calculate the students age on the eval date.
In my access table I have Date of Birth (DOB) and Date Of Evaluation (DOE). How do I write a formula to calculate the students age on the eval date.
=Text(DOE DATE - DOB DATE,"YY")
=Text(DOE DATE - DOB DATE,"YY") Do I just add "MM","DD" behind the "YY"?
or =DATEDIF(DOB,DOE,"y")
where
y - how many years
m - how many months
d - how many days
or if you want count all
=DATEDIF(DOB,DOE,"y")&" years "&DATEDIF(DOB,DOE,"ym")&" months and "&DATEDIF(DOB,DOE,"md")&" days"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks