P
PeteyP
How/where would I kick off the GetBusinessDay function in the following query
expression. I want to calculate 120 days ahead and, if that date falls on a
weekend or holiday, get the next business day.:
Express1: IIf([Ident]=4 And
[Formal]=0,DateAdd("d",+120,[CCRScopeInitSigDate]),"0")
I have successfully used GetBusinessDay in the following:
PlanD1: IIf([Deadline]>#1/1/2001#,GetBusinessDay([Deadline],-20))
Tried searching for an answer and hope I didn't miss it. Thanks in advance
for the help.
expression. I want to calculate 120 days ahead and, if that date falls on a
weekend or holiday, get the next business day.:
Express1: IIf([Ident]=4 And
[Formal]=0,DateAdd("d",+120,[CCRScopeInitSigDate]),"0")
I have successfully used GetBusinessDay in the following:
PlanD1: IIf([Deadline]>#1/1/2001#,GetBusinessDay([Deadline],-20))
Tried searching for an answer and hope I didn't miss it. Thanks in advance
for the help.