past due date

[Joel_112]

I new to these forums, and I hope I can explain myself correctly.

I have an invoice data base and in one layout I'm able to see what invoices are unpaid and outstanding.

These are the fields I'm using:

invoice

inv_date

inv_datePaid

invElsaped calculation > If(inv_datePaid="","", inv_datePaid - inv_date)

When I'm paid, I enter the date in the inv_datePaid field and I can see how many days have past...this works fine.

I have created a new layout for receivables ...My terms are net 30 days,so an invoice is not past due until 30 days have past. I made two new fields

days_outstand and days_pastDue.

days_outstand calculation > Today- inv_date

days_PastDue calculation > Today- inv_date + 30

my definitions are missing something but I'm not sure what it is...can someone please help ... Thank you

[Kurt Knippel]

I closed this thread in the Scriptmaker forum, please do not post into multiple forums, pick the most appropriate one.

Anyway, what is the goal? What are your trying to do with this date?