title: Hive: date range is not fetching the data from the table
body: <p>I am new to this platform. Trying to accomplish a task in Hive but failing to get it done.</p>
  
  <p>Have a table with the following structure:</p>
  
  <p><code>Table1:</code></p>
  
  <pre><code>ID DATE       VAL1  VAL2  VAL3
  01 12/12/2017 12.23 56.45 78.9
  02 05/06/2019 65.88 65.22 98.22
  03 09/08/2018 86.00 23.00 56.05
  04 09/19/2019 34.09 75.04 77.89
  05 03/16/2018 87.45 45.56 89.89
  06 06/06/2018 67.66 45.00 67.90
  07 01/01/2018 23.21 90.99 56.33
  08 07/03/2018 67.22 67.22 33.11
  09 05/13/2017 12.12 98.33 78.89
  </code></pre>
  
  <p><code>DataTypes:</code></p>
  
  <pre><code>ID   INT
  DATE STRING
  VAL1 DOUBLE
  VAL2 DOUBLE
  VAL3 DOUBLE
  </code></pre>
  
  <p><code>Hive Query:</code></p>
  
  <pre><code>SELECT * FROM Table1 WHERE DATE BETWEEN date_format(current_date + 
  interval '-12' month,'MM/dd/YYYY') AND 
  date_format(current_date,'MM/dd/YYYY');
  </code></pre>
  
  <p>This above query is not fetching the records from the table.</p>
  
  <p><code>Actual O/P:</code></p>
  
  <pre><code>OK
  Time taken: 65.515 seconds
  hive&gt;
  </code></pre>
  
  <p><code>Expected O/P:</code></p>
  
  <pre><code>ID DATE       VAL1  VAL2  VAL3
  02 05/06/2019 65.88 65.22 98.22
  03 09/08/2018 86.00 23.00 56.05
  04 09/19/2019 34.09 75.04 77.89
  06 06/06/2018 67.66 45.00 67.90
  08 07/03/2018 67.22 67.22 33.11
  </code></pre>
  
  <p>Any help to point out the mistake or missed part in the query will be really helpful. Thanks in advance.</p>