Member Avatar for newbie26

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

  • 2 Contributors
  • 2 Replies
  • 125 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by newbie26
Member Avatar for hkdani

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.

Member Avatar for newbie26

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.