Issue in business days

[#1]

Hi,

Can someone please help me with this issue.

Submitted Date - 06/02/2015
Decision Date - 06/04/2015

I want to calculate calendar days and business days

Calendar days = [Decision Date] - [Submitted Date]
It returned 2, which is correct

But for business days

I wrote the expression as, =NetWorkDays([Decision Date] , [Submitted Date])
I'm getting result as 0
But it should also be 2 right, since there are no holidays between June 2 and June 4

Thanks in advance.

Regards,
Sachin

[maxgro]

i get 3 (I have DD/MM/YYYY)

=NetWorkDays('02/06/2015', '04/06/2015')

try

NetWorkDays([Submitted Date], [Decision Date] )

from Qlik help

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

[fvelascog72]

Hi,

I think the expression should be Initial Date, Final Date:

=NetWorkDays([Submitted Date],[Decision Date])

[alexandros17]

I think that the problem is due to date format ...

[pratap6699]

=NetWorkDays([Submitted Date],[Decision Date],{optional for no of holydays})