Recent content by keithstg

Thanks! I will give that a shot. Ideally, the business days requested, if not =5, would be =3, and the second IIF string would be used. I separated the two possible days (3 and 5), but if the code you proposed doesn't work, how would I structure the formula to account for a business days...

Sorry - I didn't paste the entire formula - the missing " is my issue. Double checked the formula in the form and it has a complete set of "'s. Any other thoughts? I think that perhaps having the IIf[business days requested]=5 is the issue...

Hello All, I have created a form for user entry, that will measure a set of information against a business day deadline. However, there are two potential business day deadlines -3 and 5. I was able to create a formula that correctly captured the five day deadline: [=IIf(IsNull([arrival...