Control Next three months of 2nd Date using 1st Date
Hi All,
PFA two excel sheet.
E1 - contains sales data of a product.
UniqueID filed is the unique no assigned to a particular sale.
SaleDate is the date of sale occurring.
U2- contains data of complains that are been sold.
ProductClaimNo - is the unique ID assigned when the complaint is registered.
ClaimDate :- the date when complaint is registered.
UID :- its the foreign key to E1 table, its the same UniquID which has been sold and now a complaint is registered for it.
Now as per E1 data, all the sale has been done in Jan - 14.
Now my requirement is :-
If I select Jan - 14 from SaleDate from E1, I should know all the complaints registered in next 3 months from ClaimDate
i.e. Feb, Mar & Apr.
Out of all those complaints in next three months of ClaimDate, only those complaints should be shown whose SaleDate from E1 is in Jan-14.
Eg:- 20 products have been sold in Jan - 14 (according to E1)
Total 20 Complaints have been registered in month of Feb, Mar, Apr & May.
Out of those 20, 16 complaints have been registered in the month of Feb,Mar & Apr (next three months) for those products which were sold in Jan - 14 .
So when I select Jan-14 (or any other month)on the basis of saledate, i should get only those complaints whose UniqueID matches UID in next three months.
I have tried left joining, concatenating the data but it didn't work out.
