I have to build a complex serial number. It should include the type of document, the Jear/Month and a serial number.
It looks like that:
a) O-1908-12345-Q3 or (O is standing for Order, 1908 for 2019 August, serialnumber, Q3 for quarter of year
b) I-1911-12345-Q4 (I for Invoice)
the serial numbers should be incremented so long as the month is changed. In a new month, the serial numer should begin with 1
Sample: O-1908-12345-Q3 --> O-1909-00001-Q3
How can I realize it? I tried out many ways: SQL, separate Table,...