title: How to filter pandas dataframe based on date value with exact match
body: <p>I have been trying to filter my data frame for the specific date although the date is present in the data frame but it doesn't return any results</p>
  
  <p>Data in Data frame based on query</p>
  
  <pre><code>df[df['Date'] &gt; '2017-03-20']
  </code></pre>
  
  <p>returns this results</p>
  
  <pre><code>StaffID     Date        
  90047   2017-03-20 19:00:00     
  90049   2017-03-20 19:00:00     
  90049   2017-03-27 19:00:00     
  </code></pre>
  
  <p>although when i am running this query</p>
  
  <pre><code>df[df['Date'] == '2017-03-20']
  </code></pre>
  
  <p>or</p>
  
  <pre><code>df.loc[df['Date'] == '2017-03-20']
  </code></pre>
  
  <p>it returns me no results at all just an empty data frame</p>
  
  <pre><code>StaffID     Date
  </code></pre>
  
  <p>my data frame column types are </p>
  
  <pre><code>StaffID                int64
  Date          datetime64[ns]
  </code></pre>
  
  <p>and i have tried above query by comparing data frame date with string as well as by converting the <strong>string date</strong> into <strong>datetime64[ns]</strong> still the same results any help please would be appreciated</p>