Validation Rule Problem

[Michael]

Hi Folks - I have have two date fields. The second date must be greater than
the first date, so I added a validation rule: >[firstdate]. It works fine
except in this situation: If someone enters a date in the second date field
by mistake, then deletes the date, the validation rule is executed with the
now blank date field. Is there a way around this? Thanks.

Michael

 

[Rick Brandt]

Hi Folks - I have have two date fields. The second date must be
greater than the first date, so I added a validation rule:

[firstdate]. It works fine except in this situation: If someone

enters a date in the second date field by mistake, then deletes the
date, the validation rule is executed with the now blank date field.
Is there a way around this? Thanks.
Michael

Use ...

 

[Michael]

That's the ticket ..... Thanks.


Michael

Hi Folks - I have have two date fields. The second date must be
greater than the first date, so I added a validation rule:

[firstdate]. It works fine except in this situation: If someone

enters a date in the second date field by mistake, then deletes the
date, the validation rule is executed with the now blank date field.
Is there a way around this? Thanks.
Michael

Use ...

FirstDate or Is Null