0

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

2
Contributors
2
Replies
5
Views
5 Years
Discussion Span
Last Post by newbie26
0

Hi,

Try this :

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

Regards
Veena

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.