I developed a review status report that shows Employee Review dates, and Next Reveiws - with a compliance percentage. Here's the quick formula:

If CurrentDateTime-{PAEMPLOYEE.NEXT_REVIEW}>15 then
"**Overdue!**"
else "Current"

This is good except that once an occurance of actual Review, it becomes "Current".


Now I need to see the actual LATE reviews. I was trying this, but it's not working:

If {PAEMPLOYEE.NEXT_REVIEW}-{REVIEW.ACTUAL_DATE}<350 then
"**LATE**"
else "Current"

We have a 15 day grace period. Is this not correct? I bet I am missing something simple.

Here's an example of a late, but not overdue(Annual Review):
Next Review = 10/01/06
Last Review = 3/15/06

This person is late, but not overdue because they DID have a review.

Make any sense.

No, it doesn't make much sense. The first part is fine. The second part is not making sense, because you seem to be missing something.

-- There was a review on 3/15/06
What does that impact? You are not specific.

-- There was supposed to be a review on 10/1/06, therefore it is now "LATE".

Why don't you just go,

If CurrentDateTime-{PAEMPLOYEE.NEXT_REVIEW}>15 then
"**Overdue!**"
else
If CurrentDateTime-{PAEMPLOYEE.NEXT_REVIEW}>0 then
"**LATE**"
else
"Current"

See how it nests?

Hope this helps.