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.
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])";
Thank You for the answer.