Validation Rule

  • Thread starter Thread starter Steve Goodrich
  • Start date Start date
S

Steve Goodrich

I have a validation rule on a date field in my table which allows a date to
be added that must be todays date or later up to a year in advance
Validation is >=Date()+365 (works perfectly)

I now need to alter this rule so you can only use a date that is 2 weeks in
the future so I tried >=Date()+14

I get a message that states " Data integrity rules have been changed;
existing data may not be valid for the new rules." "Do you want to test
with the new rules?"

I click yes then save the table. There are hundreds of dates in my table
that would be invalid. I.e. between 2 weeks and 52 weeks in the future.

Everything seems to be working fine

A couple of questions please:

Should everything be OK, or will I have problems in the future?

Is there something else I should have done?

Any advice appreciated

Steve
 
By having a validation rule like that, you've essentially eliminated the
ability to maintain history in your table.

I'd say that the validation should be done at a form level, so that it only
applies when you're adding the data, rather than at a table level.
 
Hi Doug,
Many thanks for the advice, I'll add it to the form and delete it from the
table
Steve
 
Back
Top