Date validation - current year

O

obembe

How do I use the date function so that when I enter a year in a form, the
validation will check that it's not greater than the current year? I can use
the date function but don't know how to split out just the year.

Regards,

Adetola Obembe.
 
B

Brendan Reynolds

You can use the Year function to extract the year (as an integer) from a
date. A validation rule would look something like ....

<= Year(Date())
 
O

obembe

Excellent, works a treat! Thanks, Brendan. I'd been trying:-

<= Date(Year)

and Access wouldn't accept it!

Regards,

Adetola Obembe.
 
Top