realjumper Posted March 19, 2007 Share Posted March 19, 2007 Hi, On our Intranet, staff can fill in a form requesting permission to purchase items for their department. The online form is numbered like this: NZ - 06 - 183 ....where 06 represents the current financial year, and 186 represents the form number....which is incremented by 1 by selecting the last entry in the db and adding '1' to it. What they want now is for the counter to reset to 001 for the first form filled in at the beginning of the new financial year. By using the date() function and an 'if / else' statement I can determine the start of the new finacial year, but how will I reset the counter to 000....so that the first form filled in on April 1st will have the number 'NZ - 07 - 001'? Quote Link to comment Share on other sites More sharing options...
jcbarr Posted March 20, 2007 Share Posted March 20, 2007 Check for any entries in the database for that year, if none are found then the increment equals 001 if one is found, select the max and add 1. If you need help with the code show us what you currently have and we might be able to help you edit it. Quote Link to comment Share on other sites More sharing options...
realjumper Posted March 20, 2007 Author Share Posted March 20, 2007 Thanks jcbarr...thats the exact method I am currently working on. It's looking promising so I will follow through and see what happend :-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.