1 Reply Latest reply on Apr 6, 2018 3:40 PM by AnthonyDowns

    Why is my DateDiffSQL result not  accepted in CalcRule for a Number Field

    mbath61 Apprentice

      DateDiffSQL is supposed to yield a number as a result. Works in Calculation rules. I'm trying to use it in a Calc Rule for a number field but keep getting a conversion error.

      Tried swapping the two dates to rule out that error was due to negative result.

      What hav eI got to do to count the days between two dates?

       

      Screen shots of the expression, error and control properties below