Problem with dates

Hi,

I have an access db with the following fields; dbdate, name1, name2 & id.
If the field dbdate holds a date, how can I use ASP to display those records on a particular date?
ie. If dbdate = todays date, then display those records

I have tried using Cdate but I'm obviously doing something wrong.

Please Help

Steve

Hi Mart,

Yes that is correct, sorry maybe I assummed too much when asking the question.
e.g.

On 14/4/2004 name1 = pete, name2 = steve
On 15/4/2004 name1 = mike, name2 = pete.

What I need is a script that will pull data from the database whatever is equal to the current date, as I will have a record for every day of the year.

Many Thanks
Steve

Hi,

Using that code I get the following error:-

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression

The line with the error, looks like this:-

rs.open strSQL, conn, 3, 3

The whole connection script looks like:-

<%
dim conn, rs, strconn, strSQL

strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("database.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn
strSQL = "Select * from roster where dbdate = '#" & date() & "#'"
set rs = server.createobject("adodb.recordset")
rs.open strSQL, conn, 3, 3
%>

What am I doing wrong?

The 3,3 is the cursor position, this part it's OK.

Are you sure that the dbdate field is set as a DATE field in Access? If it is, perhaps it's the single quotes. I think Access works without them.