|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
getting the date |
|
From: |
Tim |
|
Date: |
3/1/2000 11:04:25 PM |
|
IP: |
216.164.200.39 |
On my first page "sports.html" I have a drop list
<select name="thedate">
with the choice of dates: Today, Tomorrow, the next day.
The form action is "post" to "sportsasp.asp".
"Sportsasp.asp" queries our DB based on the choice from the list box. I can get it to work for any text string but cant get the date figured out. To get todays date I can
-today=CStr(date)
so on sportsasp.asp I
-dim strdate
-strdate = request.form("thedate")
then the query is: (our DB table)
-Query = "SELECT * FROM Sports WHERE date=#" & ?????? & "#
How do I take the information from my drop list (ie "today), convert it to an actual date, and insert it in my query? And then how can I get Tomorrow? (Today +1 ???)
Any help would basically save me from ripping my hair out.
-Tim |
Follow Up - Re: getting the date - Tim 3/2/2000 7:48:41 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
