Member Avatar for bornok15

I'm having problems filtering the date for my reports with access and older versions of mysql i can do this my using this query format:

Select * from transactions where xdate =#"& txtdate.text &"#

or

Select * from transactions where xdate =#"& format(txtdate.text,"mm/dd/yyyy") &"#

but now that i'm using wamp with the new version of MYSQL, the query returns 0 results even if the statement is correct. anyone who has an idea of solving this problem?

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man

use Like operan better than = operan

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.