CODEWITHSUNDEEP
ssrs-2008reportbuilder3.0
Freddie
Freddie

Reputation: 51

SSRS/Report Builder datediff in working days

I have a calculated field in my report that gives me the number of days between two fields. This is in calendar days though.

=DateDiff("d",Fields!Date_Reported.Value,Fields!EventDate.Value)

I have been asked to include number of working days and I'm struggling!

Is it possible to count the number days between these fields using only working days? eg. Monday to Friday in this case? Thanks in advance for any help.

Upvotes: 0

Views: 1793

Answers (1)

Luke Parsons
Luke Parsons

Reputation: 26

Try this:

=datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbMonday)
+datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbTuesday)
+datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbWednesday)
+datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbThursday)
+datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbFriday)

The source

Upvotes: 1

Related Questions