Hi, I want to create a unique employee name_series with format like this:
EMP-{YY}-{####}
What I want to ask is, if the year has changed, the autoincrement on {####} will continue or it will reset to start with 1 again? Like
EMP-19-0001
EMP-19-0002
and then the year changed, the name will be
EMP-20-0001
EMP-20-0002
or it will be like this
EMP-20-0003
EMP-20-0004
What I want is the autoincrement still continue no matter with year like
EMP-19-0001
EMP-19-0002
EMP-20-0003
EMP-20-0004
How to achieve that?
Thanks