Anonymous
Anonymous asked in Computers & InternetSoftware · 1 decade ago

Access Date Validation Rule?

I'm new to Access and need to set a validation rule for the date so that it occurs on the current "today's) date, or within the 90 days before the current date. Any ideas how to do this? thanks.

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Set your Validation Rule as:

    >Date()-90 And <Date()+1

    Set a Validation Text to display a custom 'error message', i.e. 'The date cannot be more than 90 days ago and cannot be a future date'.

  • 5 years ago

    ask a lawyer

Still have questions? Get your answers by asking now.