2 Replies Latest reply: May 15, 2014 9:56 AM by Oli _ RSS

    date and If-function

    Oli _

      Hi,

       

      I try to have the following formula:

       

      A=numeric field

      B=date field

       

      If(A<0;B;"")

       

      The problem is that Monarch doesn't accept this.

      Error message: Operand types

       

      I like to have only the date of B if the value of A is <0. How can it work ?

       

      Oli