to generate unique registration number.
Im trying to generate unique registration numbers. The logic for that :
format of reg number : 'baddmmyy'
dd-system.date,mm-system.month,yy-system.year
a and b - varies fro 1 - 9.
I tried to use LAPD function too, but couldnt put up the logic.
pls get me coding so that every user logging in will generate new unique reg no.
first reg no should be - 01ddmmyy and last number should be - 99ddmmyy.