Display timespan as number of days
When the textbox executes this code:
=Fields!EndDate.Value-Fields!StartDate.Value
If the difference is 25 days, it will display it as 25:00:00:00.
How can I get it to simply display as "25 days" ?
Thanks for your help. I've tried all kinds of formatting expressions and adding code to the report, but nothing has worked so far.
June 23rd, 2011 1:33am
Hi
Use the DateDiff function.
=DateDiff("d", Fields!StartDate.Value, Fields!EndDate.Value).
HTHCraig Bryden - Please mark correct answers
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 1:49am