Problem: Need to account for delays in review process.
The field "EC2WL" is when an employee submitted a case to the Work Leader for review and the field "WL1stReview" is when the Work Leader first reviewed the case. If the difference between those two dates is greater than 7 days, the case is considered delayed. When a case is delayed, the amount of delay is calculated by subtracting 7 from the difference in days between the two fields.
Similarly, a case delay can happen at the section manager level. The fields to consider here are "FODReview" which is the date the case is submitted to the section manager, and "SM1stReview" the date the section manager first reviews the case.
I need these delays to sum in the field "CaseDelay" when I mailout a case.
I currently have a functioning ElseIf code that populates "CaseDelay" with a placeholder of "69" when certain conditions are met that would require a case delay to be calculated. I need to replace the "69" with a functioning piece of code.
Private Sub Mailout_AfterUpdate() If Me.FODReview > #1/1/1980# Then Me.CaseDelay = "69" Else Me.CaseDelay = "" End If