Re: Find for customers who have not recently purchased

Name    : 
E-Mail  : 
Subject : 

Comments:
: : Sue, I want a list of all customers for a particular product who have not purchased in the past 90 days.

: : The find assistant has no choice for an order date NOT after a certain date, or NOT between two dates.  Can you think of some other way in which I can do this?

: If all you want is customers who have not ordered anything in the last 90 days, you can set that up on the Customer View. Remember, to find "customers" you need to do that on a view that is based on that database!

: 1) Go into Design mode, and then select the Create menu, Field Definition.

: 2) Add a new field named LastOrderDate as calculated type with this formula: SMax(ordhead:1.ORDERDATE) and set the "Summary Options" to "All records in ordhead:1". Ok out of Field Definition.

: 3) Add your new LastOrderDate field to the Customer View outside of the order list panel. If you have it set up properly, it will show the date of the most recent order in it for the current customer. 

: You can now do a Find on that view and put < 4/1/2004 in the LastOrderDate field to find all customers whose last order was before the first of April 2004. Or put in a date range if you want to exclude people who have never ordered anything -- something like 1/1/2000...3/31/2004 in that LastOrderDate field.

: There are no views in ODP V2 or V3 that are set up to find customers who have not ordered a particular product in the last x days. It is complicated to set up, but I have done so on a custom basis for a few customers. Let me know if you want a price for this addition to your ODP.

: Sue Sloan


Optional Link URL:  
Link Title:         
Optional Image URL: