How? 2 gen a 4 digit # preceded by month and yerar?

S

Shell

I would like to generate a PO number using the following

month/day/#### so it appears as, using todays date for example:
0508-0001

Is this possible for a Form?

Thank you in advance.
S
 
K

Klatuu

The first part is easy
Format(Date,"mmdd")
How do you want to determine the rest?
What will you do next year when the numbers start recurring?
 
S

Shell

Hi Dave, and thanks for ther reply

Glad you asked - I expected that the new year would start the new number and
the 0000 would roll over after 9999. The numbers for date ned to be 2 digits
each. that is, Month ## and year ## (last 2 for year of course) followed by
the 4 digit.

Many thanks for your help.
 
Top