1 Reply Latest reply: Feb 4, 2013 9:38 AM by Henric Cronström RSS

    Stuck on expression

      Hello I have a problem with an expression :-

       

      if([Contact Date]-Date<='7',money([Sum Paid]))

       

      Contact Date refers to when the customer contacted me.

      There are payments in the past and future of this date.

       

      I am trying to link when the customer called me to pay and the payment clearing on account within a 7 day period. For some reason this is returning a null argh.

       

      Please help.

       

      Paul.