|
||||||
|
IIF Function for Future Dates By Richard Rost ![]() ![]() 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? MembersThere is no Extended Cut for this video. LinksIIF Function: https://599cd.com/iif
|
||||
| |||
Keywords: TechHelp Access Using the Microsoft Access IIF Function to Return Future Dates Based on Criteria - DateAdd, Relationships PermaLink IIF Function for Future Dates in Microsoft Access |