tried many method but no close to what i want  please help..... All I need is IN-yymmdd-serial number, once new date then serial number reset and start from 1 automatically.

just like below image

 

Thanks everyone

 

 

Edited January 12, 201610 yr by HHC
missing image

I would advise you to reconsider your requirement, because it is not easy to implement reliably.

Exactly *why* is this required? Most times I have seen requests like this, it's more about it looking nice, than being really needed...

IN-160113-02321
IN-160114-02322
IN-160114-02323

Is still unique, has the date embedded, and is fairly easy to set up so that it will work reliably.

Reason why we needed becuase daily we receiving and sending lots of mail, we using this as referenceID to locate, sort, process.

with 3 information into 1 combinaion, easyier for us and our customer identify the parcel where, when and which.