Validation rule (dates)

[Danny]

I have the following date fields: AppDate, ReassessDate, RedetDate etc. I want these dates to be less than EligDate, so I can put in the Validation text something like 'Date you entered must be less than EligDate...' when the users enter dates greater than EligDate.


Thank you in advance!

Danny

 

[Mile-O]

Is EligDate in the same table? Is it guaranteed that it will be filled in before the others? Are you performing the validation at form or table level?

 

[Danny]

validation rule

Yes, EligDate is in the same table and it's not guaranteed that it will be filled in before the others. Since I wasn't sure how to perform the validation at form level, I was trying to perform it in table level.
Just to clarify, the reason EligDate field has to be greater than other date fields is that I have another field called EligibilityDays, which is the result of the following calculations:

EligDate - AppDate
EligDate - ReassessDate
EligDate - DueDate

Thanks,
Danny

 

[Danny]

validation rule

Hi,
Can you please give me an example how to go about doing this in the form's BeforeUpdate event? I even tried to use validation rule in form's design view, but no success.

Thanks,

Danny

 

[Danny]

Validation rule

Hi Pat,
I’ve tried the above and got: Compile Error: Expected Function or variable where I have Me.AppDate.SetFocus = True and only when I comment out Me.AppDate.SetFocus = True then it works fine.

Thanks,

Danny