-
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…
Custom "Range of Years" for "Standard Date Field" in Salesforce
Have you ever noticed that the standard date field shows year Range to only up to 7 years? What if we want that Range to…
Popular Salesforce Videos
Add In-App Guidance to Salesforce Lightning Experience
In Lightning Experience, add prompts that appear on-screen to users working in an app. Use prompts to onboard and train users, highlight configuration changes and…
Einstein Opportunity Scoring For Everyone | Salesforce
Let artificial intelligence help you and your sales team focus on the right opportunities and close more deals. See how Einstein Opportunity Scoring makes it…
How To Use Dynamic Prefill Link of Formstack | Learn Salesforce Series by Algoworks
Learn how to use ‘Dynamic Prefill Link’ of Formstack in 4 easy steps! 1. Introduction Short introduction of FormStack and its uses. 2. The need…