Thomas Kuriakose
Active Member
Respected Sirs,
We have report in our ERP system which gives dates in dd.mm.yyyy format.
We need to arrive at categories based on the date values. Kindly find attached a file with desired result in column C.
If the date value is 00.00.0000 it should give category as A
If the date is 2014 it should give category as B
If the date is 2015 it should give category as C
If the date is 2016 it should give category as D
Kindly let me know how to get this result.
Thank you very much,
with regards,
thomas
We have report in our ERP system which gives dates in dd.mm.yyyy format.
We need to arrive at categories based on the date values. Kindly find attached a file with desired result in column C.
If the date value is 00.00.0000 it should give category as A
If the date is 2014 it should give category as B
If the date is 2015 it should give category as C
If the date is 2016 it should give category as D
Kindly let me know how to get this result.
Thank you very much,
with regards,
thomas