Problem in @Businessdays

HCL Domino Domino Forum
1

I have a time-date computed field “fd_holidays” that contains multiple dates calculated from a view as follows:

@DbLookup( “Notes” : “NoCache” ; “” ; “Holidays” ; x_fd_location ; 2)

I have another computed field “fd_finaldays_issue” calculated as follows :

@BusinessDays(creation_date_it; d_fd_creation;

1 : 7;fd_holidays)

The issue is that @Businessdays formula is not working for fd_holidays , it just removes saturdays and sundays but does not remove the dates mentioned in “fd_holidays”.

Any tips?

Regards,

Aisha Ishrat.

2

Subject: Problem in @Businessdays

verify that hardcoded date values works with @BusinessDays?

then check that fd_holidays field is prior to fd_finaldays_issue on your form or subform?

3

Subject: RE: Problem in @Businessdays

Resolved :). I had done some other stupid mistake.

Thanks.

Regards,

Aisha Ishrat.

4

Subject: Problem in @Businessdays

Aisha, A wild guess…Field displayed in column 2 of holiday view is not of date-time type!!!

AR

5

Subject: RE: Problem in @Businessdays

No , It is of time-date type. :frowning: