dates null problem

[Guest]

Dear all,

I generate invoices for customers who rent out stuff from me. I have
startdate and returndate for all the assets I allocate to the customer. While
generating invoice I need to;
a. select all the customers where assets are still allocated by passing a
month say June 2007 and this should select all the transactions that ocured
before 30 june 2007.
b. my transactions are as follows for example;
AllocatedDate ReturnDate
01-01-07 NULL
02-01-07 15-06-07
03-02-07 30-06-07
15-02-07 15-05-207
16-02-07 NULL
19-02-07 NULL
04-03-07 20-10-07
05-03-07 16-11-07
06-04-07 NULL
09-04-07 NULL

Problem:
1. I am finding it diffcult to pass a criteria for the report so that only
those transactions are selected which are less than the invoice date and all
the other old transactions which have completed to be NOT included.

2. Also I apply discounts to all customers who take stuff from me after the
15th of invoice month and who return stuff before the 15th of invoice month.

Thanks

 

[Guest]

Hi Lazarus,

If I understood right you need to build a query to select all the records
having the AllocatedDate different than today date and ReturnDate NOT NULL.

You can use Date()-1 to select all the records having yesterday date for the
AllocatedDate attribute and Not Null for the ReturnDate attribute.

I hope that helps.

Carmen