title: Convert Access 2007 date/time to text, mm/dd/yyyy to yyyy-mm-dd
body: <p>I need to convert a Date/Time in Access (it comes from an Oracle database but Access is the only tool I'm allowed to use to access it) to plain text. </p>
  
  <p>I have found lots of web pages that talk about how to convert from text to date, but I have not found any that can convert date to text without having to code a VBA function. I would like to find an Access 2007 way to do this:</p>
  
  <pre><code>SELECT TO_CHAR(TO_DATE(PURGE_DATE ,'mm/dd/yyyy'),'YYYY-MM-DD')
  FROM PATRON; 
  </code></pre>
  
  <p>How can I do this?  I've been beating my head against this for three hours now. </p>
  
  <p>I did some more searching and found that this works for part of my need:</p>
  
  <pre><code>SELECT format(PURGE_DATE ,'YYYY-MM-DD')
  FROM PATRON;
  </code></pre>
  
  <p>That flips the fields around, but it does not convert it to text.</p>