DJ P
asked on
Date Differences SSRS
Good afternoon. I am just starting to play around with SSRS. I have a report I created from a SharePoint list (if that matters). I have two date fields once called created and the other called completion_date. With in the report I went into the text box properties for both and formatted the date to read m/d/yyyy on both fields. Basically I removed the time.
I then created a text box called NumberofBusinessDays. It is in this field that I want to return a value not counting weekends on the difference between the field created and the field completion_date. So for example:
Created Date = 10/17/2016 Completion Date = 10/20/2016 then NumberofBusinessDays = 3.
How do I accomplish this for a newbie?
I then created a text box called NumberofBusinessDays. It is in this field that I want to return a value not counting weekends on the difference between the field created and the field completion_date. So for example:
Created Date = 10/17/2016 Completion Date = 10/20/2016 then NumberofBusinessDays = 3.
How do I accomplish this for a newbie?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER