title: Convert Date to correct format
body: <p>I have CSV file with incorrect date format 19-08-22:01:00 (yy-MM-dd:HH:mm)</p>
  
  <p>When I open it in excel it is not showing in date format. So I would like to convert this value using powershell.</p>
  
  <p>I tried to change it using below command. But didnt work</p>
  
  <pre><code>$d = '19-08-22:01:00'
  get-date $d
  </code></pre>
  
  <p>Could someone please help me to convert the date in correct format in which excel recognize it as date.</p>