title: Recordset .value property
body: <p>Please see the DDL below:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE TestDate (bookingdate datetime)
  INSERT INTO TestDate VALUES ('2013-10-04')
  </code></pre>
  
  <p>Please see the ADODB recordset below:</p>
  
  <pre class="lang-vb prettyprint-override"><code>rs.open "SELECT bookingdate FROM TestDate"
  If rs("bookingdate") &gt; dateadd("yyyy", -6, Now)
    msgbox("test")
  end if
  </code></pre>
  
  <p>What is the difference between specifying <code>rs("bookingdate")</code> and <code>rs("bookingdate").value</code>.  I have read some questions on here where answerers say always use .value, but it is not explained why.  I had a look on MSDN but could not find an answer.</p>