LO Base, how to create/restart incremental numbering?

asked 2020-04-03 00:36:16 +0100

arzie2000 gravatar image

updated 2020-07-20 15:35:40 +0100

Alex Kemp gravatar image

We have an ordering system that uses the current date as a reference/serial number. The numbering somehow goes like this: YYMMDD-CC, the YYMMDD is the date while the CC starts with 1 on the start of the day and increments, and restarts the numbering again on the next day. image description


any help will be grateful, thanks!

edit retag flag offensive close merge delete

Comments

Hello,

Not a very convincing requirement - ...numbering somehow goes like...

Is that the requirement or not?

What DB is being used? LO version? Is this a Primary Key?

Ratslinger gravatar imageRatslinger ( 2020-04-03 04:13:46 +0100 )edit