Date validation - current year

  • Thread starter Thread starter obembe
  • Start date Start date
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.
 
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())
 
Excellent, works a treat! Thanks, Brendan. I'd been trying:-

<= Date(Year)

and Access wouldn't accept it!

Regards,

Adetola Obembe.
 
Back
Top