Age validation rule 17-65
I need to use a validation rule that checks how old a person is by their date of birth.
Here is what i have so far, 6205 is the number days a 17 is alive, the difference in the date of birth must be more or equal to this, however it must be less that 23725 the number of days a 65 year old is alive.
6205<=DateDiff("d",[Date of Birth],[Employment Date]) And 23725>=DateDiff("d",[Date of Birth],[Employment Date])
Any help appreciated