Can't Grab A Record From A .mdb Table

There's only 15 rows in the table 'FiscalYr', but I can't grab the row I need.

Here's 3 typical rows:

..Year...Start..........End...... Column names = 'year', 'start', 'end'
2003 12/29/2002 12/27/2003
2004 12/28/2003 12/25/2004
2005 12/26/2004 12/24/2005

For example, if the value of 'today' is #07/10/2004", I want the record where the key is 2004. In fact, any value for 'today' between 12/28/2003 and 12/25/2004 should pull up the '2004' row.

Here's my non-functioning code:

SQL = "SELECT * FROM FiscalYr WHERE Start >= #" & today & "# AND End <= #" & today & "#"
Set rs = DBConn.Execute(SQL)

The resultSet obviously should have only one record because the Start and End dates are unique and don't overlap from row-to-row.

but when I:

if rs.recordcount >= 0 Then
response.write. "There are " & rs.recordcount & "rows that match your search."
else
response.write "While attempting to tally a RecCount there is an Error with recordset. <br />"
end if

I keep getting the Error msg. What am I doing wrong?