I am simply looking to create a on-time vs. past due script. I have 3 columns (revised due date, original due date, and date closed). I want the following to take place. It works for the most part but I am getting false-positives on some data rows. Any help you can provide would be greatly appreciated!
- IF revised due date is empty, look at the original due date
Compare the original due date to close date. If the close date is after original due date it should write "Past-Due" into the row-level column.
Else if revised date is not empty...Compare the revised due date to close date. If the close date is after revised due date it should write "Past-Due" into the row-level column.
Else it should write in On-Time.
IF (AND(OR (Internal_Audit_Issue__c.Issue_Resolution_Due_Date__c <= Internal_Audit_Issue__c.Date_Closed__c, Internal_Audit_Issue__c.Revised_Due_Date__c <= Internal_Audit_Issue__c.Date_Closed__c)), "Past-Due","On-Time")