date-time is reuired here crystal report problem

[newbie26]

hi.how can i filter dates from the database in crystal report syntax?
i tried {tblname.datetimefield} >= format(text1,"yyyy-mm-dd") and (tblname.datetimefield} <= format(text2,"yyyy-mm-dd").

but this gives me error, "a date is required here".
my database field is in datetime data type.with format 0000-00-00

i also tried Date({tblname.datetimefield} )>= format(text1,"yyyy-mm-dd") and Date({tblname.datetimefield} <= format(text2,"yyyy-mm-dd"). but still it gives me error.

im using mysql, vb6 and crystal report 8.5.

please help me.
i need this..thanks..

[QVeen72]

Hi,

Try this :

" {tblname.datetimefield} In Date(" & format(text1,"yyyy,mm,dd") & ") " _
& " To Date(" & format(text2,"yyyy,mm,dd") & ") "

Regards
Veena

[newbie26]

hey QVeen72. Thanks for the reply.
It works.
many Thanks.. :-)