Please see the DDL below:
CREATE TABLE TestDate (bookingdate datetime) INSERT INTO TestDate VALUES ('2013-10-04')
Please see the ADODB recordset below:
rs.open "SELECT bookingdate FROM TestDate" If rs("bookingdate") > dateadd("yyyy", -6, Now) msgbox("test") end if
What is the difference between specifying
rs("bookingdate").value. 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.