Page 1 of 1

How to convert timespan to exact numeric value

Posted: Tue Jul 08, 2008 6:04 am
by 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

How to convert timespan to exact numeric value

Posted: Tue Jul 08, 2008 7:45 am
by Edward
Hello.

Please modify an expression as follows:

Code: Select all

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