By using this website, you agree to our Terms of Use (click here)
I am trying to create an inquiry to select customers who have not previously had an invoice in the last 180 days and then made a purchase in the past 7 days. I have tried many different ways to do this but with no success. I can get those that have not purchased in the last 180 days and tried to add ARInvoice in a second time with an alias to get the last 7 days but cannot get the conditions to work properly. Any ideas or thoughts on how to do this?
Thanks
Sharon
I think you could use the Wyatt.ERP technique as outlined in this post (click here).
That post is a completely different application of the technique, but I think it would work for your situation if you did one join to get all Invoices prior to the last days, then another join for all Invoices in the last 7 days.
@timrodman - Thanks Tim, I will check this out. I ended up adding several new columns to identify which "bucket" the invoice would belong in and then did a filter.
