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.)
Go back