IIF Function to Return Future Dates Based on Criteria
Nancy from Clarksville TN asks: I'm having trouble using the DateAdd function with the IIF function. I've got a field named [Exposure Type] which could be "Positive" or "Contact". If the exposure is Positive, I need a date 11 days after the exposure date. If Contact, I need 15 days. How can I do this?
IIF Function: https://599cd.com/iif
FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Email Me: firstname.lastname@example.org
Please feel free to post your questions or comments below. Thanks.