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

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

    sheuerman

      Title

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

      Post

      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?


      Thanks!

      Sandi