Nicole Taylor’s Profile

Community member since May 2019

points
16

3

Hello,

I am trying to create a status of "Adheres" or "Past Due" based of off comparing two date fields (A Target Date and an Actual Date).  When I use this formula I get what I need.

=IF([Target Audit Start Date]8 > [Actual Audit Start Date]8, "Adheres", "Past Due")

 

The issue is that the actual