im doing somthing similar, using the following code:



If Request.Form("status") = "pendweek" Then

	Set WO = Server.CreateObject ("ADODB.Recordset")

	Query = "SELECT * FROM WorkOrders WHERE Pending_due >=#" &

DateAdd("d",7,Date())& "# ORDER BY ID"

	WO.Open Query, Connect

End IF





mine works, in that it dosent throw back any errors, but i dont get any

results.



any sugestion?

-----Original Message-----

From: nickm@s... [mailto:nickm@s...]

Sent: Wednesday, January 31, 2001 3:15 PM

To: ASP Databases

Subject: [asp_databases] Re: How to sum the return from a recordset

between specified dates..





Hi:



Thanks for the SQL but I am still getting this error:



Select sum(employee_time)AS SUMTIME FROM DevNotes WHERE DevNoteDate BETWEEN

#31/01/01# AND #24/01/01# WHERE employeeID= 'Santo';

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



[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in

query expression 'DevNoteDate BETWEEN #31/01/01# AND #24/01/01# WHERE

employeeID= 'Santo''.



/reports.asp, line 37



AND this is the suggested SQL:



strSQL = "Select sum(employee_time)AS SUMTIME FROM DevNotes WHERE

DevNoteDate BETWEEN #" & Date() & "# AND #" & DateAdd("d",-7,Date()) & "#

WHERE employeeID= '" & id & "';"



Thanks,



Stefan





----- Original Message -----

From: "Wally Burfine" <oopconsultant@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Wednesday, January 31, 2001 2:56 PM

Subject: [asp_databases] Re: How to sum the return from a recordset between

specified dates..





> do it this way:

>

> strSQL = "Select sum(employee_time)AS SUMTIME FROM DevNotes WHERE

> DevNoteDate BETWEEN #" & Date() & "# AND #" & DateAdd("d",-7,Date()) & "#

> WHERE employeeID= '" & id & "';"

>

>

>

> >From: <nickm@s...>

> >Reply-To: "ASP Databases" <asp_databases@p...>

> >To: "ASP Databases" <asp_databases@p...>

> >Subject: [asp_databases] How to sum the return from a recordset between

> >specified dates..

> >Date: Wed, 31 Jan 2001 13:17:12 -0500

> >

> >Hi:

> >

> >I want to be able to sum the employee_time within 7 days of the date of

the

> >query. In other words; I want to be able to return how many hours a given

> >employee has worked in the last 7 days. I used this SQL statement and it

> >gave me the error right underneath:

> >

> >strSQL = "Select sum(employee_time)AS SUMTIME FROM DevNotes WHERE

> >DevNoteDate BETWEEN #Date# AND #Date-7# WHERE employeeID= '" & id & "';"

> >

> >AND THE ERROR:

> >

> >Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

> >

> >[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)

> >in

> >query expression 'DevNoteDate BETWEEN #Date# AND #Date-7# WHERE

employeeID

> >'Santo''.

> >

> >/studiowebback/reports.asp, line 33

> >

> >Thanks a lot.

> >

> >Stefan

> >

>