I believe it's the use of TO_DATE that's causing the issue, since you're using it on a date field.