topic Re: Diff two days in QlikView

Diff two dates

master_student — Thu, 05 Oct 2017 13:30:33 GMT

Hello Guys,

I need your help

I have to count the difference between two dates without counting the sundays

Any idea please ?

Thanks

sunny_talwar — Thu, 05 Oct 2017 13:31:49 GMT

May be look here:

suryaa30 — Thu, 05 Oct 2017 13:35:04 GMT

master_student — Thu, 05 Oct 2017 13:56:36 GMT

i see that the solution is to create a function, how to do that please?

Thanks

sunny_talwar — Thu, 05 Oct 2017 14:00:44 GMT

Function is give by Gysbert in that link

Function GetWorkDays(StartDate, EndDate)

dCount = 0

For dt = StartDate To EndDate

If WeekDay(dt) <> 1 Then

dCount = dCount + 1

End If

Next

GetWorkDays = dCount

End Function

suryaa30 — Thu, 05 Oct 2017 14:01:42 GMT

Use SET on top, something like this

below example is Not your case:

SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + month($1))) + 1);