title: LotusScript FTSearch on date fields
body: <ul>
  <li>I have a form with several Text fields and two Date fields, called - created and Deadline.</li>
  <li>I have full text search index on database</li>
  </ul>
  
  <p>I'm trying to create dynamic search. So, on search form i added all fields, which i want to use in search and on Action search script generate query, which then used in FTSearch function. Everything works great with text fields, but with Date fields - something is going wrong. The result of search doesn't meet my expectations.</p>
  
  <p>This is how my fields are represented in view:</p>
  
  <pre><code>created     Deadline    
  08.10.2014  10.10.2014      
  08.10.2014  14.10.2014      
  06.10.2014  10.10.2014
  </code></pre>
  
  <p>Those are examples of my search query:</p>
  
  <ul>
  <li>"[created] >= 04.10.2014"</li>
  <li>"[created] >= 04.10.2014 &amp; [created] &lt;= 07.10.2014"</li>
  <li>"[created] >= 06.10.2014 &amp; [Deadline] >= 08.10.2014"</li>
  <li>"[created] >= 03.10.2014 &amp; [created] &lt;= 05.10.2014 &amp; [Deadline] >= 08.10.2014 &amp; [Deadline] &lt;= 11.10.2014"</li>
  </ul>
  
  <p>But as i said - returned results have nothing similar with search query. What can be wrong? </p>
  
  <p>Example: 
   - all documents</p>
  
  <pre><code> Created        Deadline            
   09.10.2014 10.10.2014
  
   03.10.2014 09.10.2014
  
   08.10.2014 10.10.2014
  
   08.10.2014 14.10.2014
  
   07.10.2014 09.10.2014
  
   06.10.2014 10.10.2014
  
   06.10.2014 10.10.2014
  
   03.10.2014 06.10.2014
  </code></pre>
  
  <ul>
  <li>query "[created] >= 07.10.2014"</li>
  </ul>
  
  <p>result - all changes</p>
  
  <ul>
  <li>query "[created] >= 07.10.2014 &amp; [created] &lt;= 09.10.2014"</li>
  </ul>
  
  <p>result - 0 documents</p>
  
  <ul>
  <li><p>"[Deadline] >= 09.10.2014"</p>
  
  <ul>
  <li>result - all documents</li>
  </ul></li>
  </ul>
  
  <p>This is how i call it and show in view:</p>
  
  <pre><code>    Set col = db.FTSearch(query, 0 )        
      Call col.putallinfolder("Search",True)
      Call ws.ViewRefresh 
  </code></pre>
  
  <hr>
  
  <p>Can it be, that problem caused by fact, that fields created and Deadline store date without time? </p>