title: Clean up excessive words in a date field
body: <p>I have a text filed called "TempD" in an Access table MissingTF469Temp. This field will update the date by finding it from a long string after a specific word "Effective Date". But due to a recent change in the actual string it is taking an extra letter "I" at the end of the date in some instances. I'd like to have an sql code to remove this excessive character. </p>
  
  <p>Any help please.</p>
  
  <pre><code>Tue, Mar 29, 2016
  Wed, Mar 9, 2016I
  Fri, Apr 22, 2016
  Fri, Apr 1, 2016 
  Mon, Apr 4, 2016 
  Mon, Apr 25, 2016
  Mon, Mar 21, 2016
  Wed, May 11, 2016
  Fri, Apr 1, 2016 
  Mon, Apr 4, 2016 
  Mon, Apr 4, 2016I
  Mon, Apr 4, 2016I
  Mon, Apr 4, 2016I
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 11, 2016
  Fri, Mar 18, 2016
  Fri, Mar 18, 2016
  Mon, Mar 21, 2016
  Mon, Mar 21, 2016
  Mon, Mar 21, 2016
  Mon, Mar 21, 2016
  Mon, Mar 28, 2016
  Fri, Apr 1, 2016 
  Fri, Apr 1, 2016 
  Fri, Mar 4, 2016I
  Tue, Mar 8, 2016I
  Tue, Mar 8, 2016I
  </code></pre>