I am making a request form with a uniqe FORM NO. in order to recall the data faster. The FORM NO. is formated as follows, yyyyMMdd-000 the 000 will be incremented for every transaction made that's easy... but the problem is how to reset it back to 000 the following day?
20110713-000 (for the first transaction)
20110713-001 (for the second transaction)
20110713-002 (for the third transaction)
. (and so on)
then the following day, the number should go back to 000
with out reseting it manually