How to convert timespan to exact numeric value

[ngaheer]

Hi,

I use DateDiff function in my report. I set this fuction like this {Format("{0:N2}", DateDiff(Today,CmfActions.cmfaDate))}.
It returns me result as "23:00:00" but i want only the exact difference like onle "23". so can you guide me how can i get the accurate result.

Thanks

[Edward]

Hello.

Please modify an expression as follows:

Code: Select all

{DateDiff(Today,CmfActions.cmfaDate).Days}.

Thank you.