USING SQL - retrieve data BETWEEN (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

boggi -> 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 -> 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





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875