create a reservation number?

  • Thread starter Thread starter Arjan
  • Start date Start date
A

Arjan

Hi All,

I have a question.. I want to create a unique reservation number, for
invoice payments etc..
However, I want the reservation number to be build from two things;

first: the year we live in minus one 0 i.e. 2006 = 206, 2007 = 207, 2008 =
208 etc..
second: I want to add 3 digits to the 'year'number. These 3 digits will
start as 001 and every new reservation number will be added with 1.
so eventualy the reservationnumbers will look at this:
206001
206002
206003

Further more, when a new year starts a new serie has too begin..
207001
207002
207003

etc..

Is there anyone who can help me?

Thanks in advance..

Arjan
the Netherlands
 
see answer posted in other newsgroup where you posted this question.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to create a reservation number? 18
auto numbering without auto number field 8
Create a Custom Project Number 6
Creating an auto-incrementing serial number 2
Creating a sequence number 19
create a button which displays the next available preformatted num 3
Generating Random Numbers... 10
Formula for converting xx/xx/xxxx dates to a number between 1 and 2

Back
Top