-
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
Back Up Metadata to Secure and Restore Your Customizations | Salesforce Guide
You can protect your organization’s customizations, like customized fields, custom Apex code (Everything you wrote in your console), page layouts, reports, and permission sets, by…
All You Need to Know About Creating Free Salesforce Developer Account
Are you struggling to create a Free Salesforce Developer Account? Do you think you could not find the right resources to guide you step-wise free…
How To Use Picklists In Salesforce Marketing Cloud
Picklists you say? Picklists are basically dropdowns used to let users choose from a series of values. Picklists can help you simplify data entry (time…
Popular Salesforce Videos
Salesforce For Beginners - Introduction To Salesforce | Salesforce CRM Developement Tutorials
Contents for this Salesforce Training Video: 1:05 - Index 1:31 - What is CRM ? (Customer Relationship Management) 2:17 - What is Salesforce CRM? 3:18…
5 Things Salesforce Lightning Does Better
In this 30-minute recorded webinar, Jamie Grettum talked about her favorite Lightning features, how to set them up, and how to get hands-on experience with…
How to Edit or Change Product Schedules in Salesforce
Use product schedules to determine the payment and delivery cycles for products that are paid or delivered over time. In Lightning Experience, customize schedules with…