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
 
Back
Top