find records based on date

[matcathy]

Given two dates, start_date and end_date.
How can I retrieve all records from the database, a create_date attribute is specified in the table, that are within the given date interval?


e.g.
start_date = "8/13/1999"
end_date = "11/12/1999"

records to retrieve should be in the range of the two given date.


Thanks.

[msdnexpert]

Try this
Select * from abcd where efgh >= DateValue(startdate) and efgh <= datevalue(enddate)

efgh is the date field in the database

[JorgeLedo]

MSDNexpert was right but try it this way:

stdate= DateValue(start_date)
eddate= DateValue(end_date)

"Select * from abcd where efgh >= #" & stdate & "# and efgh <= #" & eddate & "#"

------------------
Jorge Ledo
j_ledo@hotmail.com
Portugal