title: reset auto increment number each year
body: <p>I have a table with <code>job_no</code> to be auto increment with the last two digit of the year.</p>
  
  <p>Example: in year <code>2014</code> the <code>job_no</code> will be like this: <code>140001</code>, <code>140002</code>, <code>140003</code> and it will keep increment until next year which is <code>2015</code>, it will reset the count like this: <code>150001</code>, <code>150002</code>...</p>
  
  <p>it happened that I knew how to merge date with the numbers, but am still unable to figure out how to let it reset yearly.. I will be so thankful for your help and will be glad for a clear view of explanation and examples...</p>