You all have been a great help in the past, thought I'd give it a go again. This time...I'm looking for a formula that will allow results of one field to be based on a date range in another field.
Scenario: A customer can have many products on their invoice. Invoices are produced on the anniversary of the date of when the product was added. Meaning, if the product was added to the customer on 10/2, it would appear on the invoice for 11/2.  The invoice table has an 'issue' date. The products table has a 'bill to' date. I would like to pull just the products that would have appeared on an invoice for a particular month. The problem is, a product could have been added to the customer after that month's invoice was produced so using the same date ranges for 'issue date' and 'bill to' date won't work. I would like to somehow have the product 'bill to' date either match the invoice 'issue date' or be within the previous 30 day range of the invoice table's 'issue date'. Example: For Nov, a customer has an invoice issued on 11/2. That means the products on that invoice would have a 'bill to' date of 10/2 thru 11/1. I have tried various different syntax of formula's I have found around the web...Aged0to30days, etc. I hope you can help me out and that I provided enough info for a resolution.
Thanks a bunch, Cindy

Thanks for getting back to me.
Yes, different tables, the "issue date" is in the invoice table, the "bill to" date is in the products table. They are joined successfully. The format for both dates is mmddyyyy hh:mm:ss. Invoices are issued monthly. Unfortunately,  I'm not CR savvy enough to write a stored procedure.

Yes, I have grouped by invoice number and need to remove those products with a date newer than the invoice issue date. I think part of the problem is with the invoice issue datetime and product bill-to datetime, while they have the same mm/dd/yyyy they have different times. I tried converting those fields to just mm/dd/yyyy so that I could use a formula on the product such as: if the billtodate.producttable is greater than the issuedate.invoicetable then N else Y to then filter out the N's. But that is not working.