Validation Rule

1

1

I am trying to set up a validation rule in which a date
field can not be populated if two other fields are not
equal to each other.
The date fields input mask is set up as follows
99/99/00;0;_
How would I set up the validation rule-
I have tried [fieldA]=[FieldB]
but I think with the input mask set up as it is when you
delete the figures it still thinks that their is something
populating the date field. Is that possible? Thanks in
advance for your assistance.
 
M

Michel Walsh

Hi,



(DateField IS Null) IMP iif(field1 = field2, -1, 0)


if field1 neither field2 can be null, then just

(DateField IS Null) IMP (field1=field2)





Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rule assistance 0
Date format -medium date input mask-French Canadian 5
Validation Rules for a Control on a Form (?) 4
Input Mask for General Date/Time 1
Create a Validation rule for IBAN Account nos in a form field 0
DATE PROBLEM 4
europe date format / input mask 1
Validation Rule Error Messages 1

Top