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
instead of 'varDate' use #varDate#
WiL