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

Recommended Answers

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.

Jump to Post

All 2 Replies

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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.