title: If there is the Solr Query for 2 different date columns
body: <p>We have created the table in Hive, and the records from the table are indexed in Apache Solr.</p>
  
  <p>The table has fields like MY_START_DATE AND MY_END_DATE.</p>
  
  <p>When triggering the hive query as below:</p>
  
  <pre><code>SELECT MY_TABLE.COMPANY_NAME, MY_TABLE.MY_START_DATE, MY_TABLE.MY_END_DATE
  FROM MY_TABLE 
  WHERE 1 = 1  AND 
       FROM_UNIXTIME(UNIX_TIMESTAMP(MY_TABLE.MY_START_DATE),'yyyy/MM/dd') &gt;= 
       FROM_UNIXTIME(UNIX_TIMESTAMP('07/02/2016', 'MM/dd/yyyy' ),'yyyy/MM/dd') AND 
       FROM_UNIXTIME(UNIX_TIMESTAMP(MY_TABLE.MY_END_DATE),'yyyy/MM/dd') &lt;= 
       FROM_UNIXTIME(UNIX_TIMESTAMP('07/13/2016', 'MM/dd/yyyy' ),'yyyy/MM/dd') 
  LIMIT 1000;
  </code></pre>
  
  <p>It gives total of 292 records.</p>
  
  <p>But when trying to execute the same in Solr as below</p>
  
  <pre><code>MY_START_DATE:[2016-07-02 TO * ] AND MY_END_DATE:[ * TO 2016-07-13]
  </code></pre>
  
  <p>It gives only 47 records.</p>
  
  <p>Can someone please help to get the correct Solr query, which will match with Hive query?</p>