title: CSV separates Date in two cells
body: <p>PowerShell program reads data from fixed Database in format Month Day, Year.</p>
  
  <p>CSV outputs Month and Day in one cell, and Year in next cell.</p>
  
  <p>How to fix this? I tried putting single and double-quotes around <code>$i[6]</code> and <code>$av_date</code>, and it still doesn't work </p>
  
  <p>Code snippit</p>
  
  <pre><code>foreach ($i in $sql_output){
      $computer_name = $i[0]
      $ip = $i[1]
      $computer_domain = $i[2]
      $computer_os = $i[3]
      $current_group = $i[4]
      $sep_version = $i[5]
      $av_date = $i[6]
      Add-Content D:\Script\Reports\IP_Status_$date.csv "$computer_name,$ip,$computer_domain,$computer_os,$current_group,$sep_version,$av_date"
  }
  </code></pre>
  
  <p>Output where entire date is not under Antivirus Date column</p>
  
  <p><img src="https://i.stack.imgur.com/CGZtt.jpg" alt="enter image description here"></p>