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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

To check date range

Status
Not open for further replies.
sandyas

sandyas

Programmer
Apr 20, 2006
31
US
I have two dates(range) which is entered through ASP form in MM/DD/YYYY format. The date in the table is stored as YYYYMMDD. I converted d1 and d2 to that form. It has to be checked with the date in the table.

"Select date1 from table1 where date1 between '" & d1 & "' and '" & d2 & "'"
I get a syntax error.

 
Sort by date Sort by votes
It's working. I used the = instead of between.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to Execute Create View code in Actian Zen?
Replies
1
Views
258
mirtheil
mirtheil
profoundhypnotic
  • Locked
  • Question
how to select min and max value and the date for each
Replies
1
Views
264
mirtheil
mirtheil
profoundhypnotic
  • Locked
  • Question
How to read a csv file in Pervasive?
Replies
1
Views
319
mirtheil
mirtheil
Papagovas
  • Locked
  • Question
Conveting a char to date 1
Replies
18
Views
516
Papagovas
Papagovas
Ino Mart
  • Locked
  • Question
How to use a variable as table name in a procedure 1
Replies
2
Views
222
Ino Mart
Ino Mart

Part and Inventory Search

Sponsor

Back
Top