Calculate Age - How To Build a Complete Genealogy Family Tree Database With Self-Joins and Forms in Microsoft Access


	Back to Genealogy Seminar Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Calculate Age

Roxanne Drachenberg

3 years ago

Following along on Genealogy Seminar Lesson 04 time 16:00 on Public Function CalculateAge(d1 as date, d2 as date) as long
CalculateAge = CalculateAge = DateDiff("yyyy", d1, d2) + (DateSerial(Year(d2), Month(d1, Day(d1)) > d2)
First error said expected: ) so I added another ) at the end because I couldn't find a missing one.
Then I get this error: Compile error: wrong number of arguments or invalid property assignment and it takes me to the public function calculateage mentioned above.
Please help.
Thank you in advance.

	Richard Rost @Reply 3 years ago
You typed the formula wrong. I can see one too many ) in there toward the end. Double-check it.

	Kevin Robertson @Reply 3 years ago
Actually the correct amount of parentheses, but one is in the wrong place. Hint: Month function.

	Richard Rost @Reply 3 years ago
Uh... yeah... what he said. :)

	Roxanne Drachenberg OP @Reply 3 years ago
Boy, I just could not see that. I looked through the line seven times and never saw that. Thanks!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Genealogy Seminar.

Next Unseen

New Feature: Comment Live View