$filter and $select in Web.Contents() Query

I'm trying to write a dynamic query that looks at a date parameter (DateParam).  The following works but the Service does not allow scheduled refresh because it's a dynamic query:     I'm tr...