Simple Date Comparison Formula - When two dates are equal to each other....

[a-train]

Hello!

I've had some frustrations with this report I generate once a month that checks to see if tasks are done on or before their due date. Sometimes it works, and others it doesn't...

The basic formula is:

Please Login or Register  to view this content.

If they closed their task by or before the due date, the condition should be true and it should output "Compliant" beside their task. Otherwise their "Over Due".

The forumla works except when they close their task ON the due date. No matter how I tweak the forumla, it thinks the condition is false as if it cannot tell when the two dates match. Is it me? I couldn't find anything specific to this issue anywhere I've searched so far. Help or guidance is greatly appreciated!

[BadlySpelledBuoy]

Could you post some sample data and point out where this should show Compliant but doesn't?