title: Convert long date stored as text to short date Access SQL
body: <p>I am trying to convert a long date stored as text to a short date via MS Access SQL.</p>
  
  <p>For example I have a table which parsed information from a website and one of the field is Tuesday, June 17, 2014. I want to run an update query in another table which takes this value and converts it to 17/06/2014.</p>
  
  <p>Any help on what functions I can use please?</p>
  
  <p>thanks</p>
  
  <p>Elton</p>