title: How to change/format just the time part of date in non-american format?
body: <p>I have a date/time field in my CSV file in <strong>d/m/yyy h:nn:ss AM</strong> format.</p>
  
  <p>CSV is linked in MS Access and I want to convert the above field to <strong>dd/m/yy hh:nn</strong> format.</p>
  
  <p>Sounds easy, but when I try <code>Format([Date Processed], "dd/m/yy hh:nn"</code> in my sql, it switches the <strong>dd</strong> and <strong>m</strong>. So <strong>12/4/2015 (4-Dec-2015)</strong> becomes <strong>12/4/15 (12-April-2105)</strong></p>
  
  <p>I do not want to play with my computer's date format as it may break my application. How can I do this within my SQL?</p>