admin 1/7/2014 | |
There is a 'date' field in invoices table. You can modify the SQL query in question to find the highest invoice number among current year invoices only. select ... from ... where year(date)=year(now()) |
F
|
futo author 1/16/2014 |
There is a 'date' field in invoices table. You can modify the SQL query in question to find the highest invoice number among current year invoices only. Something like this: select ... from ... where year(date)=year(now())
|