Evaluate Macro and @BusinessDays

HCL Domino Domino Forum
1

The following LotusScript statement (part of a field exiting event code in a form) produces “Error in EVALUATE macro” message. Can anyone tell me why?

vResult = Evaluate ( {@BusinessDays( @Date(LeaveStart) ; @Date(LeaveEnd); 7:1))}, doc )

2

Subject: Evaluate Macro and @BusinessDays

I think you have too many closing brackets after 7:1

Try this:

vResult = Evaluate ( {@BusinessDays( @Date(LeaveStart) ; @Date(LeaveEnd); 7:1)}, doc )

As a tip, next time copy your formula code into an action button or something - this will give you an error message relevant to the formula