On Sat, 15 Jan 2011, Andrus Moor wrote:
> There are 365 days in year. Do you really think pre-creating sequence for
> every day for every year is best solution ?
Andrus,
I just saw this thread so my idea may not work for you. What I'd do is use
the Julian date (that is, the sequential day from 1-365/6) followed by 1, 2,
or 3 digits depending on how many invoices are generated each day. Makes
sorting and comparisons simple.
Rich