I posted this yesterday, but I guess there was a problem with my userid or something.
TheAceMan1 posted a reply, but I did not get to read it and I can't find the post now. Here goes again:
Reference thread702-1172513
The referenced thread shows how to create a numbering system based on the fiscal year (October 1).
I used part of the ELookup Function to produce ECP06-001, ECP06-002, etc. where 06 is the current year. How do I restart the numbering for January 1, 2007, to get ECP07-001? My system goes from ECP06-048 to ECP07-049. It gets the year correct, but does not restart at 001.
TheAceMan1 posted a reply, but I did not get to read it and I can't find the post now. Here goes again:
Reference thread702-1172513
The referenced thread shows how to create a numbering system based on the fiscal year (October 1).
I used part of the ELookup Function to produce ECP06-001, ECP06-002, etc. where 06 is the current year. How do I restart the numbering for January 1, 2007, to get ECP07-001? My system goes from ECP06-048 to ECP07-049. It gets the year correct, but does not restart at 001.
