title: DATEPARSE in Tableau turning all months into January
body: <p>I have been connecting Tableau to a csv data source.  I have two date columns.  When I tell Tableau they are date columns it imports the entirety of both columns as Nulls.  I tried to import them as strings and create a calculated date column out of each with DATEPARSE.</p>
  
  <p>I ran this ([Close Time] is the string from the CSV)</p>
  
  <pre><code>DATEPARSE("mm/dd/yyyy hh:mm:ss",[Close Time]) 
  </code></pre>
  
  <p>and named the column "Close_Time_DT"</p>
  
  <p>The result was: </p>
  
  <p>Close Time                  </p>
  
  <ol>
  <li>'05/30/2013  11:20:50'</li>
  <li>'05/30/2013  18:01:53'</li>
  <li>'06/05/2013  02:02:49'</li>
  </ol>
  
  <p>Close_Time_DT</p>
  
  <ol>
  <li>'1/30/2013 11:20:50 AM'</li>
  <li>'1/30/2013 6:01:53 PM'</li>
  <li>'1/5/2013 2:02:49 AM'</li>
  </ol>
  
  <p>Clearly this is wrong, I tried also with </p>
  
  <pre><code>DATEPARSE("m/d/yyyy hh:mm:ss", [Close Time])
  </code></pre>
  
  <p>and got the same result.
  Thanks in advance for your help</p>