I have 2 fields, "Dues Paid" and "Dues Due On" to calculate if dues are current or delinquent. However, the code is not working. Say the dues are paid yesterday and today is the due date. The word "Delinquent" should NOT show but Current should. However, that is not the case. How do I make it so if dues are paid today and due yesterday, it will still show current and not delinquent?

If ( Dues Paid > Dues Due On ; "Delinquent" )

 and 

If ( Dues Paid < Dues Due On ; "Current"  )

how about this one:

Case (Dues Paid > Dues Due On; "Delinquent"; "Current")

Perhaps adding:

Case(

   IsEmpty( Dues Paid ) and Get(CurrentDate) > Dues Due On; "Delinquent"; 

   Dues Paid > Dues Due On; "Delinquent"; 

   "Current"

  )

Ok, a different way of getting the same problem. If I do that, and put dues are due 3/5/2009 but are paid today, delinquent shows up still.

Inconceivable!

due.zip

Hmmm...I had one field text...OOPS! Thanks this works great;)

It will work great tomorrow, too - IF you make the calculation unstored.

Ok, here is a twist..My customer would like to make this reflect a 30 day period. So if X pays on 01/01/2008 then dues would be due on 02/01/2008. Making the dues due on a calculation now to reflect the due date. But also changing the "current/delinquent" notification status. Any idea?

This is not a good arrangement to have. You should have a separate record for every period, ot at least for every payment made. Otherwise you may have someone who paid for January, but didn't pay for February until March - but the calc will show them as current.

Indeed...I guess I need to make a "Payment" record separate and have it related to show the status. As tired as I am this is going to be fun...LOL...