New to Access. Need help with age validation rule.

[domtriga]

I need help with my validation rule.

I need to have the field only allow data to have certain birthdates(In the mm/dd/yyyy format). And to only allow people to sign up if you're between 16 and 70 years old. My instructor asked us to use the Now() function to do this.

I basically got this, and it's not really working at all.

The field is BirthDate

"(Now()-[BirthDate]/365)>=16" And "(Now()-[BirthDate]/365)<=70"

My instructor assigned this on my second week so any help would be greatly appreciated.

[June7]

Try:
DateDiff("d",[BirthDate],Date())/365 BETWEEN 16 AND 70

Or use Now() in place of Date()

[domtriga]

That worked and thank your for this.. But is there anyway you can do it with the Now() function?

I think he will be ok with this but I just want to know how to do it with Now()

EDIT: Nevermind, I just replaced Date() with Now() and it also works!!

Thank you so much. I will definitely be browsing these forums more often, especially with this class.