Hi all, I have 3 dates for each customer. An offer Creation date, A contact date ( not all are contacted, and an offer accept date ( customer can accept without being contacted. I want help to create following data shown in table. The "Status Day 0" is the offer creation date. For each day i need to classify the customers to one of the following statuses: Status Description 1 offer accepted after contact 2 offer accepted without any contact 3 Offer still not accepted but contacted 4 offer still not accpted but were not contacted I appreciate all your help. Regards, Amit Final table: CustID OfferCreation Contact_Date AcceptDate Status day0 Status day1 Status day2 Status day3 Status day4 1 02Jul2012 4 4 4 4 4 2 13Aug2012 15Aug2012 4 4 2 2 2 3 29Jun2012 02Jul2012 4 4 4 2 2 4 29Jun2012 26Jul2012 4 4 4 4 4 6 13Aug2012 15Aug2012 15Aug2012 4 4 1 1 1 7 22Aug2012 25Aug2012 4 4 4 3 3
... View more