Categorise my customers into C0,C1,C2,C3 based upon there last s

[Closed]
Report
-
Hello,

i want to categorise my customers into C0,C1,C2,C3 based upon there last service date & Date of Delivery. C0 are the customers who are not reporting to my workshop from last six months,
C1- reporting to workshop and Less than one year old Customer
C2- Above one year and below two year Customers
C3- Above two year customers,
C0- Non reported to workshop from last six months to workshop,

Can you help me on this