Forums

This topic is locked

Filter recordset by time ?

Posted 17 Nov 2002 10:33:49
1
has voted
17 Nov 2002 10:33:49 suhail kaleem posted:
Hi !
i have date field in my acess db
now i want to filter recordset by time1 to time2 ?? how can i do that

any help
suhailkaleem

Replies

Replied 18 Nov 2002 09:35:06
18 Nov 2002 09:35:06 Vince Baker replied:
Use the SQL Between command.

Select *
FROM tablename
WHERE date BETWEEN time1 AND Time2

(If you are using MS Access you will need to do the following)

Select *
FROM tablename
WHERE date BETWEEN #time1# AND #Time2#


Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 18 Nov 2002 13:43:34
18 Nov 2002 13:43:34 suhail kaleem replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Use the SQL Between command.

Select *
FROM tablename
WHERE date BETWEEN time1 AND Time2

(If you are using MS Access you will need to do the following)

Select *
FROM tablename
WHERE date BETWEEN #time1# AND #Time2#


Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>



hi !
tried this it always give me empty recordset

&lt;%
Recordset2__date1 = request.querystring("time1"

Recordset2__date2 = request.querystrinng("time2"

Recordset2__q = request.querystrinng("qid"

set Recordset2 = Server.CreateObject("ADODB.Recordset"
Recordset2.ActiveConnection = MM_nhs_STRING
Recordset2.Source = "SELECT * FROM answers WHERE Date_answered BETWEEN #" + Replace(Recordset2__date1, "'", "''" + "# AND #" + Replace(Recordset2__date2, "'", "''" + "# AND QID='" + Replace(Recordset2__q, "'", "''" + "'"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 3
Recordset2.Open()
Recordset2_numRows = 0
%&gt;

Any help ?
suhailkaleem

Reply to this topic