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?
Members
There is no Extended Cut for this video.
Links
IIF Function: https://599cd.com/iif
DateAdd: https://599cd.com/dateadd
Relationships: https://599cd.com/relationship