-
How to Filter empty date field in SF analytics api?
Using the analytics rest api we need to add a filter to a date field to get only the records where this field is empty. In json: { "column": "Account.Date_Field__c", "operator": "equals", "value": "" },
This filter is also shown if you fetch the report meta data from SF, so the syntax should be correct.
Till the rollout of Summer 14 release it was working as expected, after the release change we get the error message "Filter the date in the correct format. Accepted formats are yyyy-MM-dd'T'HH:mm:ss'Z' and yyyy-MM-dd.]" I checked to use null, but this leads to an error "574902135-2760 (-2136086741)"
Any ideas how to filter on empty date field?
Log In to reply.
Popular Salesforce Blogs
What is Salesforce? A Definitive Guide!
Salesforce is a type of software that includes CRM management and workforce management and enables us to manage customer relationships, customer service management, marketing campaigns,…
How to Increase Your Sales Leveraging Digital Transformation? | Salesforce Guide
Now, the shopping experience is not confined to stores. It has been spread across multiple channels including online, mobile, and over the phone. With shoppers…
Popular Salesforce Videos
How Users Set Up Einstein Activity Capture | Salesforce Tutorial
Say goodbye to busy work. Say hello to smarter selling. When you connect your email and calendar to Salesforce with Einstein Activity Capture, their email…
4 Benefits of Salesforce Vlocity Communications Clouds
Vlocity Communications effortlessly collaborate with Salesforce Service Cloud to design a solution to garner personalized and uninterrupted experience for customers throughout their channels. This not…
Salesforce for Manufacturing: How to Digitize Your Sales Processes
As a manufacturing sales leader, you’re looking for ways to go digital with your sales processes and improve channel performance. In this video, you’ll learn…