SQL Date Between Query

[xres]

Hey guys, I'm in need of your help!
I have an access database with a field called datee (Yes it has 2 e's) which is set to memo. In there is dates with the format dd/mm/yyyy. I need to develop a query to select between two dates.
e.g 12/02/2002 12/02/2003
I have tried so many things, from the BETWEEN function, to the ODER By function but to no avail. The between function only brings back results between the the dd section and ignores the month and year altogether.

<code>
SELECT *
FROM tbldata
WHERE datee BETWEEN ='#Form.startdate#'' AND '#Form.enddate#'
</code>

Any help greatly appreciated
thanks

[Vidhura]

Hey guys, I'm in need of your help!
I have an access database with a field called datee (Yes it has 2 e's) which is set to memo. In there is dates with the format dd/mm/yyyy. I need to develop a query to select between two dates.
e.g 12/02/2002 12/02/2003
I have tried so many things, from the BETWEEN function, to the ODER By function but to no avail. The between function only brings back results between the the dd section and ignores the month and year altogether.

<code>
SELECT *
FROM tbldata
WHERE datee BETWEEN ='#Form.startdate#'' AND '#Form.enddate#'
</code>

Any help greatly appreciated
thanks

SELECT *
FROM tbldata
WHERE datee BETWEEN startdate AND enddate

before giving the value from form,convert the startdate and endate to datetime type

[xres]

SELECT *
FROM tbldata
WHERE datee BETWEEN startdate AND enddate

before giving the value from form,convert the startdate and endate to datetime type

How would I go about converting it to datetime?
thanks

[SkinHead]

Generate two new variables

DECLARE dtStart as Date
DECLARE dtEnd as Date
 
dtStart = CDate (Form.startdate)
dtEnd = CDate (Form.enddate)
 

Then :

SELECT *
FROM tbldata
WHERE datee BETWEEN dtStart AND dtEnd