web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Need to have the follo...
Microsoft Dynamics GP (Archived)

Need to have the following SSRS expression results to show just a number

(0) ShareShare
ReportReport
Posted on by Community Member

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

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at

    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)

  • Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    I tried changing it in the number and the date, but it did not change anything.  Any other ideas?

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at

    Did you attempt the DATEDIFF formula?

  • Community Member Profile Picture
    Community Member on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans