DayspastDue calculation

[webhead]

Hello,

I am wondering if someone can help me out with this. first, i am running FM. 6. What i am trying to do is figure a away to find past due day of student who has no made any payment. i have two DB, one is call Students and the other Ledger.

In the Students DB, I create a portal which input the data to Ledgers. So i need to figure out how many days has past since someone made a payment. Here are the fields i have created in the Ledgers DB. Posted Date, Charges, Amount, Category. i am wondering if the issue has to do that we use the posted date field for both the charges and Amount.

There is a relationship on both DB base on studendID field.

any help would be appreciate it. Than you

Vic

any help will be appreciate it.