Hi all,

I would like to create a serial nnumber for invoices purposes. I would like to have so that the first 3 digits are letter, then month and year, then a serial number. The problem that I am having is that I would like the date to appear as 1205 for december 2005, but all the time the year appears as 4 digits (122005). Any tips?

Thanks

Nik.Be

Hi

try this:

Your3Chars & Month ( Get ( CurrentDate ) ) & Right ( Year (Get ( CurrentDate ) ) ; 2 ) & YourSerial

Thanks raybaudi. Exactly wat I was looking for.

Ciao

Nik.Be