C
CC
Hello-
I am trying to set a validation rule in a form.
The validation rule is going to be applied to "approval
date" and it references "# in Batch" and "Sum of Batch".
This is what I currently have:
[# in Batch]>[Sum of Data Entered] or [# in Batch]<[Sum of
Data Entered] And [Approval Date] Is Null
I don't want an approval date entered if # in Batch and
Sum of Data Entered do not match... my problem is when the
validation rule is not satisfied and I delete the numbers
in the approval date field and it still does not allow me
to save the record. The Approval date field's Input Mask
is set to "99/99/00;0;_" - could that be what is causing
the problem, if so, what do I do to fix that?
Thank you in advance! CC
I am trying to set a validation rule in a form.
The validation rule is going to be applied to "approval
date" and it references "# in Batch" and "Sum of Batch".
This is what I currently have:
[# in Batch]>[Sum of Data Entered] or [# in Batch]<[Sum of
Data Entered] And [Approval Date] Is Null
I don't want an approval date entered if # in Batch and
Sum of Data Entered do not match... my problem is when the
validation rule is not satisfied and I delete the numbers
in the approval date field and it still does not allow me
to save the record. The Approval date field's Input Mask
is set to "99/99/00;0;_" - could that be what is causing
the problem, if so, what do I do to fix that?
Thank you in advance! CC