Error when using a Date filter for an external object report
Last updated 2021-04-06 ·Reference W-3962569 ·Reported By 3 users
Error when adding filter on Close Date to report based on Standard Report Type for External Data Object
"We encountered an unexpected error. Try again later, or contact your administrator, who can verify the external data source settings and the external system's availability. Error received from the external system: \nCreatedDate FROM Opportunity WHERE CloseDate\u003E=2017-07-03T00:00:00.000Z\n ^\nERROR at Row:1:Column:119\nvalue of filter criterion for field \'CloseDate\' must be of type date and should not be enclosed in quotes."
1. Create one cross org connector external object
2. Create a report based on the above object
3. Choose a Date filter (not All Time)
Use a date filter of All Time
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.