I still cannot see any point in generating a serial number just to generate a unique index when combined with the date. The example provided by arnelgp shows the use of an autonumber unique index. Would you do a search on that calculated unique number rather than a search by customer name or order number or anything more practical than the order of the customer on a day.
Anyway, good luck with whatever you choose to do.