Forums

This topic is locked

Search by Date

Posted 25 Jul 2002 17:21:15
1
has voted
25 Jul 2002 17:21:15 Wil Turrin posted:
Hi, I'm trying to create a search form, which will allow the user to select all of the records that have been entered after the selected date.

I set up a function to concatenate three variables into one hidden variable
(giving the full date as mm/dd/yy).

How do I set up the results page to compare dates? I have:

Select * from regTBL where requestDate >= 'varDate'

varDate - 7/23/02 - Request.Form("date"

Any help?

Replies

Replied 25 Jul 2002 17:58:33
25 Jul 2002 17:58:33 Wil Turrin replied:
Figured it out,

instead of 'varDate' use #varDate#

WiL

Reply to this topic