Date validation - current year

[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.

 

[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())

 

[obembe]

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

<= Date(Year)

and Access wouldn't accept it!

Regards,

Adetola Obembe.