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

  • Thread starter Thread starter Shell
  • Start date Start date
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
 
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?
 
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.
 
Back
Top