-
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
Top 10 Salesforce Winter ’21 Features for Reimagining your Experience Cloud Journey
As is the norm with all feature update releases, Salesforce’s Winter ’21 release is packed with features that add fluidity to workflows and help businesses achieve…
How to Hire Salesforce CPQ Developer for Business Success
In the competitive world of B2B sales, speed and accuracy are the dual engines of growth. However, as product catalogs grow and pricing structures become…
Supercharge Support Agents with These Lesser-Known Salesforce Service Cloud Features
We are living in a time when customer experience matters the most for a business. A disappointed customer will take no longer a minute to…
Popular Salesforce Videos
Salesforce Admin Certification 2020 Questions Explained with References - Part I
How to prepare and pass Salesforce Admin Certification with Practice Exam Questions 2020 practice questions and answers for the Salesforce Administration Salesforce Certified Admin Exam…
Welcome to the Partner Marketing Center | Salesforce
The Partner Marketing Center (PMC) is your one-stop shop for customizable marketing assets. By logging into the PMC you can easily access, customize, and deploy…
Salesforce Admin Beginners Tutorial - 3.1 - Salesforce Platform Basics
Salesforce is an innovative tool that can be very powerful when used properly. That’s why it’s important to find effective and trustworthy ways to learn…