title: User defined date format in VBA Access
body: <p>I can't figure out how to tell VBA the correct date format, as it seems to assume in the wrong way around. So <code>CDate("24/02/2016 10:59")</code> is giving the correct date - dd/mm/yyy. However when it iterates through a date like <code>CDate("01/03/2016 00:59")</code> - it assumes number 03 is not a month but a day so VBA is assuming it's <code>mm/dd/yyyy</code>, so it's giving me a date <code>03/01/2016</code> which is wrong and messing my data. So how can I tell VBA it's actually dd/mm/yyyy format. VBA seems to automatically pick up nicely even if it's <code>"2016/01/14"</code>, but it's failing when it's not really obvious which part of numbers are months e.g. both <code>dd</code> and <code>mm</code>are less than 12.</p>
  
  <p>I'm reading this date from a CSV file using <code>WS.Cells(irow, icol).Value</code>.</p>
  
  <p>This is what I tried so far:</p>
  
  <p><code>datDate = CDate(Format(WS.Cells(iRow, iCell).Value, "dd-mmm-yyyy hh:mm:ss"))</code></p>