Has anyone used the @BusinessDays when writing a reminder agent? I am wanting to write an agent that will send a reminder out to the users after so many days. I want to take into consideration the weekend days and the holidays when I calculate the number of days.
Thanks in advice for any comments.
Jean
Subject: Reminder agent using businessdays in the calculation
Yes, I’ve used it. I’m not sure what exactly you’re looking for though.
The tricky thing when using @BusinessDays is generating a an accurate list of holidays to pass to it.
Subject: Reminder agent using businessdays in the calculation
Hi Jean,
Yes, I've used it. Here is the code below :
Dim T As Variant
T=Evaluate("@BusinessDays(fromdate;todate;1:7; [01/01/2008] : [01/26/2008] : [03/21/2008] :[05/01/2008] : [08/15/2008] : [09/03/2008] : [10/02/2008] : [10/09/2008] : [10/27/2008] : [10/28/2008] : [12/09/2008]: [12/25/2008])",doc)
Call doc.ReplaceItemValue("Totaldays",T)
In the above example the given list of dates are which you want to exclude i.e. you want exclude business days & some other holidays(List of Holiday).
This will definitely helps you. I think this will be fulfill you requirement.