title: Convert a Text to a DateTime in access
body: <p>So i have a field that datatype is a text which is feed into the database. What it returns is something along the lines of this:</p>
  
  <blockquote>
    <p>ddd MMM dd hh:mm:ss yyyy</p>
  </blockquote>
  
  <p>What i would like for it to do is be displayed as something like this:</p>
  
  <blockquote>
    <p>ddd MMM dd yyyy hh:mm:ss</p>
  </blockquote>
  
  <p>I can achive this by using Format() which would look like this:</p>
  
  <pre><code>Format(alarmdet.AlarmStart, "ddd MMM dd yyyy hh:mm:ss) AS AlarmDateTime
  </code></pre>
  
  <p>So that is all well and good, however; i want to beable to convert this value into a datetime. I've tried using CVDate, CDate, DateValue and every time i get returned an error claiming a mismatched datatype. How would i go about converting this exact string into a datetime?</p>
  
  <p><strong>Note:</strong></p>
  
  <p>So you are aware, i am able to get it to convert successfully when in the English(united states) locale, but i am attempting to get this to work in the Portuguese(portugal) locale. In this locale i get the mismatch datatype error which i think has something to do with how access reads the abrivated months. Is there something i am missing to make this successfully work in an international setting?</p>
  
  <p>Also i would like to convert something similar to this in a different field to have it appear as so:</p>
  
  <blockquote>
    <p>MM/dd/yyyy</p>
  </blockquote>
  
  <p>Again i know i can get this using Format(), but i would like to to be converted into a DateTime. How would i go about doing this?</p>
  
  <p>Any help or suggestions are greatly appreciated.</p>
  
  <p>Thanks.</p>