I would appreciate some help with the report I am trying to create.

I have 3 date fields that I need to sum/evaluate.

Receive_by (Start of Range)

Receive_by_end (End of Range)

Receive_Actual

 

What I am trying to do is that I need to know whether or not Receive_Actual falls inbetween Receive_by and Receive_by_end, or if its received before or if it is received later than Receive_by_end. I tried using 3 different Running total with formulas as 

{Receive_ACTUAL}<{Receive_by}

{Receive_by}<{Receive_ACTUAL}<{Receive_by_end}

{Receive_Actual}>{Receive_by_end}

However, I am not getting any result using that way.

Is there a better way to do so? I would really appreciate if someone can give me an advice or better way to approach this problem.

 

Thank you in advance for your replies

Dan