title: creating primary key based on date
body: <p>I am trying to create a unique ID for each record based on the date the record is created. Example, if the record is created today, I want the key to be 20101130XX where XX would be a sequential list of numbers such as 01, 02, 03 etc... in case more than one person creates a record today.</p>
  
  <p>If 3 people created records yesterday their unique IDs would be</p>
  
  <p>2011032700
  2011032701
  2011032702</p>
  
  <p>and then midnight comes and someone creates a new record it would be</p>
  
  <p>2011032800</p>
  
  <p>The purpose of this is to give each record a unique ID that will be used to reference the ticket.</p>
  
  <p>We are already using the date format, but currently users are having to manually enter the id and that can create errors such as 2012032700 when it should have been 2011032700 so instead of putting 2011 they put 2012</p>
  
  <p>I am just not sure how to create a trigger to generate this type of unique ID and would appreciate any assistance </p>