Maybe simply removing the {value {$reported_date}} element from the field definition will do the trick - wouldn't that always set it to an empty value? Maybe it overrides whatever -select_query would have set.