You need to pass query parameters as an iterable. Make it a tuple, for instance:
cursor.execute(date_query, (mydate, ))
You need to pass query parameters as an iterable. Make it a tuple, for instance:
cursor.execute(date_query, (mydate, ))