Afrooman108
New member
- Local time
- Today, 11:05
- Joined
- Apr 23, 2012
- Messages
- 9
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
Regards
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
Regards