Query returning no rows

I have been wrestling with the issue for two days now. I created a resource from a Google Spreadsheet. Everything is connected. When I run it, it returns all the records, so I think everything is good there. I then created a resource using Query JSON with SQL to query against the data from the spreadsheet. I can return all the data just fine, but if I use a WHERE clause to only pull back certain shipping dates or serial numbers, it never finds any rows. I have checked the formats and everything else I can think, but still nothing. Any suggestions?

@tomm Can you post the Query JSON with SQL query?