-
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
Review of Top 5 Free Salesforce Data Cleansing Tools [+ Salesforce Data Cleansing Best Practices]
Keeping your CRM data clean is not only a technical activity. It also involves a creative mind, time, and deep knowledge of the business nuances…
Passing the Salesforce AI Specialist Certification with Dumpsforsure – Your Complete Success Guide
Introduction : The Salesforce AI Specialist certification has quickly become one of the most valuable credentials for professionals working in artificial intelligence and CRM technology.…
Outcome Management in Salesforce Nonprofit Cloud
Salesforce’s Nonprofit Cloud (NPC) is full of many wonderful tools to help nonprofit organizations with funding, delivering, and measuring the impact of services. A nonprofit’s…
Popular Salesforce Videos
Salesforce CRM Full Training Tutorial For Beginners
In this video, Nick Boardman explains how to use the key features inside Salesforce CRM. He explains various dashboard options, setting up campaigns etc.
Introduction to Salesforce Nonprofit Cloud for Program Management
Each nonprofit’s mission and the program is unique, but with Salesforce’s highly configurable and customizable platform, you can manage your entire program from one central…
What Is Salesforce and Why Is It So Good?
Salesforce is by far the most popular CRM tool for sales, support, and marketing teams worldwide. But what exactly is a CRM and why do…