You’re offline. This is a read only version of the page.
The following is a calculation of days in an SSRS report. It is showing the correct days but with the time stamp of 00:00:00 after it.
What can I do to make it show just the number of days? Thanks,
=(iif(Fields!RMDTYPAL.Value<=6,Parameters!I_dAgingDate.Value,0))-Fields!DUEDATE.Value
*This post is locked for comments
Yes, but received this error and I am just getting started learning how to modify SSRS and not sure how to do the declare.
The Value expression for the testrun 'Textox 560,Paragraphs(0), TextRuns(0);
contains an error: [BC30451] Name 'D' is not declared.
Did you attempt the DATEDIFF formula?
I tried changing it in the number and the date, but it did not change anything. Any other ideas?
You should be able to go into the properties of that particular field from inside the designer and format the field to show just the number.
Regards
Aaron
Try exploring the DATEDIFF function:
www.w3schools.com/.../func_datediff.asp
Should probably look something like this (sorry, didn't test):
=DATEDIFF(D,(iif(Fields!RMDTYPAL.Value<=6,Parameters!I_dAgingDate.Value,0),Fields!DUEDATE.Value)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (