Printable View
I am designing an order delivery system, and I have hit a snag...
I need to generate an invoice number with the following format (either in oracle or in business logic) YYYYDDNNNNN
like 040100001 040100002 etc etc
Hoe can this be done... the more IM thinking about the more frustrated I become :)
kind regards
Henrik
I might be miss reading what you're after but here goes....
generate the number part first (say from the ID column of your table. or from the last order ID).
Then format the date as YYMM and concatinate the 2 together as strings.
Nick
well I could do a vb method very easily, but I was just wondering if there is some kind of number format that worked like that (from right to left), any kind of sequence...??
kind regards
henrik
well i would suggest,
to split the number into two parts....
then u can always convert the number back to string, and concatenate the two strings together............
anyhow is worth trying it