Share via

Validation rule for current year?

Anonymous
2015-04-30T23:16:39+00:00

Hi,

I'm trying to set up a validation rule that only allows users to enter a year between 1826 and the current year and I'm unsure on how to set up the validation for 'current year'

Any help is appreciated

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,820 Reputation points Volunteer Moderator
    2015-05-01T12:23:49+00:00

    Year(Date()) Will return the Current year.

    But without knowing the datatype of the field its harder to advise.

    Was this answer helpful?

    0 comments
  2. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2015-05-01T04:18:40+00:00

    The expression would be:

    Year(myDateField)

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-05-01T01:41:15+00:00

    Are you using a DateTime field, Text, or Number?

    Was this answer helpful?

    0 comments