Hey Kerry Halligan,
I did some research of this on my end and found that this query seemed to work best for me. The date field in my table is SuperDate and then I compared it to what we would expect the date format to be:
qp.setWhere("date(SuperDate) > date('2046-05-05')");
This would follow the format of how SQLite tables query for date.
More information on how to format a Date query against a SQLite database can be found here:
SQLite Query Language: Date And Time Functions
Does this help?
EDIT: You may also want to move this discussion to the Android Runtime SDK section of the site. I am not sure on how to do this but maybe power user, Dan Patterson, remembers how to.
Right below the magnifying glass is an option called "Actions".
If you click that you should see an option to move and from there you can move it to the Runtime SDK for Android section of GeoNet.