|
| |
|
|
boggi
Posts: 16
Joined: 2/26/2002
From: Novo mesto Slovenia Slovenia
Status: offline
 |
USING SQL - retrieve data BETWEEN - 3/6/2002 13:24:16
Hello!
I'd like to use a drop down menu where I would have date(where I'd select day,month and year) and in order of this select than I would have onther drop down menu with this option, but at first one I'd like to select date from and at the second I'd select datee to!
So that I could retrive data between a range of data that I selected!
Thank you for help
Boggi
|
|
|
|
Mojo
Posts: 2431
From: Chicago
Status: offline
|
RE: USING SQL - retrieve data BETWEEN - 3/6/2002 17:34:35
For Access (I am guessing that your using Access) you can do this -
SELECT ID
FROM table
Where date_field
BETWEEN #1/22/2002# AND #2/22/2002#
Joe
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
