title: Get records between two String dates
body: <p>I know that data type of Date column should be Date/Time, but in my case it is Text.</p>
  
  <p>Now I want to fetch records between two dates.</p>
  
  <pre><code>String Date1=jTextField.getText();
  String Date2=jTextField2.getText();
  
  pre=conn.prepareStatement("select * from Table where Date between "Date1" and "Date2"");
  
  ResultSet rs=pre.executeQuery();
  </code></pre>
  
  <p>I know that this query does not help me. But I am totally new to sql query so please help me to solve this problem.</p>
  
  <p>Thank you in advance.</p>
  
  <p>EDIT:</p>
  
  <p>I am using MS Access Database.</p>
  
  <p>At this stage I am just printing records using System.out.println(rs.getString(1));</p>