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