Report Problems

[ianmuir]

Hi, I have a script that checks the database for debtors. You input start and end date then it looks to see if a job has been invoiced > 30 days , then checks to see if the payment received date field is blank.

It then produces a report between the 2 dates you inputted which works O.K.

What the boss wants is if an invoice was paid on 17/06/2010 and you run the report from 01/06/2010... 15/06/2010 it still shows on the the report because as of the 15/06/2010 it was not paid.

Any ideas?

[Vaughan]

You need to perform a find with two requests:

1) invoice date: start...end, paid date: =

2) invoice date: start...end, paid date: > end