Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Date

Status
Not open for further replies.
mtsw

mtsw

Technical User
Oct 27, 2002
3
MY
Hi,
i'm having extracting data from database with date condition problem. The following shown the code:

myday=request.form("day")
mymonth=request.form("Month")
myYear=request.form("Year")

dbdate = mymonth & "/" & myday & "/" & myYear
strSQL="Select * from Seminar where DFrom="& dbdate & ""

Hope anyone there reply me ASAP, thanks.
 
Sort by date Sort by votes
try this
"Select * from Seminar where DFrom='"& dbdate & "'"
or
"Select * from Seminar where DFrom=#"& dbdate & "#"


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
sql result
Replies
1
Views
155
strongm
strongm
elly00
  • Locked
  • Question
execute sql store prodecure
Replies
1
Views
136
SaltyTheFrog
SaltyTheFrog
elly00
  • Locked
  • Question
printig sql tabel from vbs
Replies
0
Views
101
elly00
elly00
iambob
  • Locked
  • Question
Change Date and Time
Replies
2
Views
398
iambob
iambob
feipezi
  • Locked
  • Question
How to change system date by VBS?
Replies
0
Views
114
feipezi
feipezi

Part and Inventory Search

Sponsor

Back
Top