Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
25
Formula Date Minus Date Needs to Be Numeric , Not Date Value
posted

I need help how to get numeric value e.g. number of days when we perform date field minus date field using in grid view using formula builder  instead of using datediff function . Is it possible to get this using formula builder.

Thank You,

Bhargavi G.

Parents
No Data
Reply
  • 469350
    Suggested Answer
    Offline posted

    Hi Bhargavi,

    There's no way to change the behavior of the minus (-) sign in a formula. But the CalcManager supports a DateDiff function just like the one in the DotNet framework.

    dateDiffColumn.Formula = "DateDiff(\"d\", [DateTime 1], [DateTime 2])";

Children