DataType error, BETWEEN, >, < DateTime field 1

[mrmovie]

Hi All,
My aim is use 2 dateTimePicker controls so user can search for entries based on dates. should be easy enough i thought.

scratching my head with the SELECT statement.
the field in question is DATA TYPE 'Date/Time/

The following works:

[Header].FromDate LIKE '01/01/2005'

These give me datatype errors

[Header].FromDate < '01/01/2005
[Header].FromDate < '" & DateValue("01/01/2005") & "'"
[Header].FromDate BETWEEN '01/01/2004'AND '01/01/2005'

ive also tried CDate.
i also tried CONVERT(CHAR(8), [Header].FromDate, 3) but i gget an error about an undeclared CONVERT something or other.
i understand that access stores the DateTIme in xxxx.xxxx

can anyone point me towards the light, please?

cheers
rich

 

[alvechurchdata]

You need to use # characters to mark the date:
[TT]
[Header].FromDate < #" & DateValue("01/01/2005") & "#"
[/TT]

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[mrmovie]

legend, i tried the # but also left in the ' so had '# if you get my drift, cheers, have a great week