A date should be stored in a date column, or at least converted to a date type in the where clause. You are doing a text search on data that isn't fully text. This means the database is trying to find strings between "J.." and "F.."
This is inherently reliable. "January 5" is before "January 28" in an ASCII sort. Which is not what you want.