how can i filter records based on dates especially when the option
is for weekly basis??

and then the report will be generated in crystal report.
any query or syntax???

i badly need this..

tnx in advance..

im using vb6 and crsytal report 8 and my database is MYSQL

You need to have the user select the week and then you need to use that week in a SQL Query statement. If you're using an ADODB recordset, it shouldn't matter what database engine you're using.

You need to have the user select the week and then you need to use that week in a SQL Query statement. If you're using an ADODB recordset, it shouldn't matter what database engine you're using.

hey.. i just found the right syntax..
when filtering date using crystal report, its different from
filtering using mysql..

:-)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.