|
you can do it in a query, I’m working on it, take the top date and compare it to the current date getdate() by year and month and day, year(getdate()) month(getdate()) and day(getdate()). Then after that you would have to compare the table against it self, looking for when there are 2 dates that are within 30 days of each other, and returning all other dates that aren't
Give me a bit of time on the code, finding people who have not made a sale in 30 days is easy, the other bit is much trickier, it may be beyond me.
__________________
Donate Blood!
"Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen
|