Format Auto Number With Date.

[prodtest]

Hi
I need to have an auto number in a date base, but I require it to have a certain format for example.

VOC-03-05-0000001

The VOC is always there but the 03-05 is the month and year, and the 0000001 is the auto number part always incrementing by 1 each record.

Any ideas ?

 

[SilentAiche]

prodtest,


There are a number of FAQs on this issue referenced in [blue]thread700-1020999[/blue].

Hope they help!
Tim


[gray]_______________________________________
Although not artistic by nature, I sure can draw a blank...[/gray]