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?