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
Try wrapping it with $(). This worked when i tested it.
Retrieving data ...