4 Replies Latest reply on Jan 16, 2012 6:20 PM by eibcga

    validating a date field



      validating a date field


      I have a date field which is used to track the date a financial transaction has reconciled with a third party, or when the related goods or services have been received or delivered.  The "reconcile date" should not be a date that is on or before the payment date.  The validate by calculation has the following formula:

      reconcile_date  ≥ Journal::date_jrnl

      Since the result is Boolean (true/false test), and I have the user cannot override during data entry set, I have a problem when I delete the value in the reconcile_date field so it's blank or null.  I would like to make the validation rule mandatory, but I must make it optional, otherwise I'm stuck in a loop.    FMP says, "Non-zero values are true, zero and empty values are false".  I dont' want an empty value to be false!  Can't I somehow work around this validation so that it only validates if the field has a value?  If the field is blank, then validation is not relevant.  Thanks.