3 Replies Latest reply on Apr 13, 2010 8:13 AM by sheuerman

    Need Help Writing an "If" Statment Please!!!



      Need Help Writing an "If" Statment Please!!!


      I have the statement but my boss asked me to only show outstanding balance's over 45 days. This is what I have so far and it brings up everything that is outstanding be it one day or 100 days.


      Commit Records/Requests []

      If [not IsEmpty( Orders_Orders__Account Number::Acct. No.)]

         Show Custom Dialog ["Payment"; "Customer has Outstanding Balanace!!!!"]

      End If



      How do I make it search if the Payment is overdue by 45 days or more? I do have field that show's how many days they are past due called "Days Past Due". Can someone help me with this?