Hello,
This is my first post, but I did some searching, and did not find specifically what I am looking for and wondering if I can have some help. We warranty products based on serial number, with a letter then numbers: N10201200799 which translates to:
N10 - model
2012 - Manufactured date (12-2020)
00799 - product serial number
I am trying to create a document that we can enter serial numbers in a column and have it display the information correctly and also state if the warranty is voided based on the manufactured date since warranty is good for one year. I am wondering if anyone smarter than me has an idea on what the best method could be used for this?
Thanks in advance!
This is my first post, but I did some searching, and did not find specifically what I am looking for and wondering if I can have some help. We warranty products based on serial number, with a letter then numbers: N10201200799 which translates to:
N10 - model
2012 - Manufactured date (12-2020)
00799 - product serial number
I am trying to create a document that we can enter serial numbers in a column and have it display the information correctly and also state if the warranty is voided based on the manufactured date since warranty is good for one year. I am wondering if anyone smarter than me has an idea on what the best method could be used for this?
Thanks in advance!