I have this Input Validation formula that ensures nobody can put in a date past today:
@If((AuDateAudited>@Today);@Failure("The Audit date can not be set to a future time.");@Success)
I'd like to allow users to leave the field blank, but this is not permissible with the above formula.
I tried using the formula below:
@If(((AuDateAudited !> @Today) | (AuDateAudited = ""));@Success;@Failure("The Audit date can not be set to a future time."))
and the designer gave me the following error:
"Inappropriate (unary) usage of an operator: ')'.
Any suggestions? (I'd rather stick with a Formula based solution than script.)