I have a database where I have two date fields, Procedure Due Date and Procedure Performed Date. I want to update a checkbox called Procedure over 30 days based on two considerations:
1 - Whenever the Perfomed Date is greated than the Due Date.
2 - Whenever the Due Date has gone by without a Performed date.
I have IIF statements where one situation works, but then wipes out everything that may have been checked by the other situation. I know that I cannot have the two IIF statemnets seperately, but I am having a hard time combining them.
Here are the two statements that I have:
IIf([Procedure Performed Date]>[Procedure Due Date],True,False)
IIf([Procedure Performed Date] Is Null And Date()>[Procedure Due Date],True,False)
I have stared at this so long, my brain hurts! Does anyone have any bright ideas?