Which is customer has not bought from US in 6 months?

Which is customer has not bought from US in 6 months?

I have been given the task of finding out which of our customers have not bought from us in 6 months and have no outstanding sales orders.

Where can I find my past purchase history?

to find details on the items you bought from as long as three years ago. To improve your help experience, please sign in to your account. Purchase history is also the central place to manage your past orders: you can contact the seller, leave feedback, and more. Simply select an action from the More actions menu next to one of your purchases.

Are there any items that are still in short supply?

It was back in March when cleaning items started disappearing from grocery stores, in the initial pandemic panic. Remember the runs on toilet paper? For three months, you couldn’t find any. But here we are, six months later, and many items are still in short supply. “Sometimes bleach, and paper towels,” one Kroger shopper told us.

What does ” not ordered in the last 6 months ” mean?

You need to define what “not ordered in the last 6 months” actually means. You have two fields with dates; I’m going to assume date_ordered has to be more than 6 months ago and ignore dateprinted as that sounds like something that happens later. Now combine that with the set of customers who have not ordered in the last 6 months.

I have been given the task of finding out which of our customers have not bought from us in 6 months and have no outstanding sales orders.

to find details on the items you bought from as long as three years ago. To improve your help experience, please sign in to your account. Purchase history is also the central place to manage your past orders: you can contact the seller, leave feedback, and more. Simply select an action from the More actions menu next to one of your purchases.

It was back in March when cleaning items started disappearing from grocery stores, in the initial pandemic panic. Remember the runs on toilet paper? For three months, you couldn’t find any. But here we are, six months later, and many items are still in short supply. “Sometimes bleach, and paper towels,” one Kroger shopper told us.

You need to define what “not ordered in the last 6 months” actually means. You have two fields with dates; I’m going to assume date_ordered has to be more than 6 months ago and ignore dateprinted as that sounds like something that happens later. Now combine that with the set of customers who have not ordered in the last 6 months.

Related Posts