Here's the formula. Does anyone know why a formula would work when running the search in the browser but not when executed in a map reduce script?

CASE WHEN {custentity_the_total_billing_amount} < 1000 THEN (CASE WHEN {custentity_last_appointment_date} >  {custentity_customer_since} OR TO_DATE({custentity_last_phone_call_date_time},'MM/DD/YYYY')  > {custentity_customer_since} THEN 0 ELSE 1 END) ELSE (CASE WHEN {custentity_last_appointment_date} > {custentity_customer_since} THEN 0 ELSE 1 END) END

Is there an Access restriction on any of the custom fields that might come into play vis a vis the Map/Reduce deployment Audience?

The script deployment executes as Administrator, so I can't imagine there would be an issue