title: Bad datetime conversion in pandas when a csv file it's opened
body: <p>I have a simple csv in which there are a Date and Activity column like this:
  <a href="https://i.stack.imgur.com/mAmsp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mAmsp.png" alt="enter image description here" /></a></p>
  <p>and when I open it with pandas and I try to convert the Date column with pd.to_datetime its change the date. When there are a change of month like this</p>
  <p><a href="https://i.stack.imgur.com/zVnwD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zVnwD.png" alt="enter image description here" /></a></p>
  <p>Its seems that pandas change the day by the month or something like that:</p>
  <p><a href="https://i.stack.imgur.com/A5Wzm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/A5Wzm.png" alt="enter image description here" /></a></p>
  <p>The format of date that I want it's dd-mm-yyyy or yyyy-mm-dd.</p>
  <p>This it's the code that I using:</p>
  <pre><code>import pandas as pd
  dataset = pd.read_csv(directory + &quot;Time 2020 (Activities).csv&quot;, sep = &quot;;&quot;)
  dataset[[&quot;Date&quot;]] = dataset[[&quot;Date&quot;]].apply(pd.to_datetime)
  </code></pre>
  <p>How can I fix that?</p>