flag unpaid invoices

[ianmuir]

Hi, I have a database which works well and produces client invoices. When an invoice is printed a field "invoice_date" records the date of invoice.

When an invoice is paid "Paid" is entered into a field "invoice_status"

How can I make a script that checks the date and the invoice_status field and if no payment has been received >30 days from invoice date flags this?

[efen]

Script?

Create a calculation field

If (IsEmpty (invoice_status field) and Get(CurrentDate) > invoice date field + 30;"Overdue"; "")

Then create a script to find all "overdue"?

[ianmuir]

thanks!!