How to calculate time between dates on a report viewer expression

Question

I have a program that uses report viewers to show various types of data to the user, and I need one of them to (basically) calculate the days between two dates WITHOUT weekends (i.e: from Friday to Monday, should show 2 and not 4).

So far, I can calculate it but with the weekends.

If anyone knows how, I'll appreciate it.

Code sample:(the formula i use on one of my tables as a expression)

CInt(Avg(DateDiff(dateinterval.DayOfYear, 
                  Fields!DataEntregue.Value, 
                  Fields!DataPrevista.Value, 
                  FirstDayofWeek.Monday)))

Verdolino: Thanks for the edition – Leonardo Jos Pereira Domingues Apr 21 '16 at 15:16 — Leonardo Jos Pereira Domingues, Apr 21 '16 at 15:16

score 1 · Accepted Answer · edited May 23 '17 at 11:59

1

From this question, I have converted Alec Pojidaev's (not accepted) answer to VB. I also returned an integer instead of double:

Public Shared Function GetBusinessDays(startD As DateTime, endD As DateTime) As Integer
    Dim calcBusinessDays As Double = 1 + ((endD - startD).TotalDays * 5 - (startD.DayOfWeek - endD.DayOfWeek) * 2) / 7
    If CInt(endD.DayOfWeek) = 6 Then
        calcBusinessDays -= 1
    End If
    If CInt(startD.DayOfWeek) = 0 Then
        calcBusinessDays -= 1
    End If
    Return CInt(calcBusinessDays)
End Function

Usage:

GetBusinessDays(date1, date2)

BTW, in the future, what you were looking for was how to calculate number of business days between two dates in [enter language here]. A quick web search for this would have brought you to a number of answers.

edited May 23 '17 at 11:59

Community

1
1

answered Apr 21 '16 at 15:25

djv

15,168
7
48
72

1º: I did made a search on the web for this, couldn't find anything that would fit in my case 2º: i used the tags to tell which language i am using – Leonardo Jos Pereira Domingues Apr 21 '16 at 15:27
Also, i kinda need to use this on an expression, so the "usage" part doesnt fit. but i'll try to adapt. thx! – Leonardo Jos Pereira Domingues Apr 21 '16 at 15:29
Leo, I searched for answers in C#, because there are a lot more people using that language. This is why I had to convert to VB. I usually have more luck searching for C# answers, even though I write mostly VB. Good luck! – djv Apr 21 '16 at 15:35
Need to check my data, but it seems to work fine. I would upvote u if i could, so .... +1 – Leonardo Jos Pereira Domingues Apr 21 '16 at 15:35
Great! You should be able to mark completed at least ... :) – djv Apr 21 '16 at 15:40

How to calculate time between dates on a report viewer expression

1 Answers1