Delinquent or Current

[Leather Knight]

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"  )

[stefangs]

how about this one:

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

[Fitch]

Perhaps adding:

Case(

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

   Dues Paid > Dues Due On; "Delinquent"; 

   "Current"

  )

[Leather Knight]

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.

[Fitch]

Inconceivable!

due.zip

[Leather Knight]

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

[comment]

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

[Leather Knight]

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?

[comment]

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.

[Leather Knight]

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...