Hi everyone,
This is probably a noob problem but I can't figure it out for the life of me.
I have a customer table with a related purchase table. What I would like to do is to set a date range and find all customers who HAVE NOT made a purchase within that range.
The issue I'm running into is if set up the query to return records between a start and an end date, only those who HAVE made a purchase appear. I can use the "is null" parameter, but that will only give me customers who have never made a purchase.
Does anyone have insight into the best approach for this?
Thanks!