Toggle Side Panel

  • Home
  • Articles
    • All Articles
    • Blogs
    • Videos
    • Infographics
  • Consultants
    • Salesforce Product Expertise
      • Top Salesforce ConsultantsTop Salesforce Consultants
      • Marketing Cloud ConsultantsMarketing Cloud Consultants
      • Service Cloud ConsultantsService Cloud Consultants
      • Experience Cloud ConsultantsExperience Cloud Consultants
      • Analytics Cloud ConsultantsAnalytics Cloud Consultants
    • Salesforce Industry Expertise
      • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
      • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
      • Health Cloud ConsultantsHealth Cloud Consultants
      • Commerce Cloud ConsultantsCommerce Cloud Consultants
      • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
    • Salesforce Experts by Location
      • USATop Salesforce Consultants in USA
      • IndiaTop Salesforce Consultants in India
      • AustraliaTop Salesforce Consultants in Australia
      • United KingdomTop Salesforce Consultants in UK
      • CanadaTop Salesforce Consultants in Canada
  • Webinars
  • Marketplace
  • Advertise With Us
  • Contact Us
  • Discussions
More options
    Sign in Sign up
    • Home
    • Articles
      • All Articles
      • Blogs
      • Videos
      • Infographics
    • Consultants
      • Salesforce Product Expertise
        • Top Salesforce ConsultantsTop Salesforce Consultants
        • Marketing Cloud ConsultantsMarketing Cloud Consultants
        • Service Cloud ConsultantsService Cloud Consultants
        • Experience Cloud ConsultantsExperience Cloud Consultants
        • Analytics Cloud ConsultantsAnalytics Cloud Consultants
      • Salesforce Industry Expertise
        • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
        • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
        • Health Cloud ConsultantsHealth Cloud Consultants
        • Commerce Cloud ConsultantsCommerce Cloud Consultants
        • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
      • Salesforce Experts by Location
        • USATop Salesforce Consultants in USA
        • IndiaTop Salesforce Consultants in India
        • AustraliaTop Salesforce Consultants in Australia
        • United KingdomTop Salesforce Consultants in UK
        • CanadaTop Salesforce Consultants in Canada
    • Webinars
    • Marketplace
    • Advertise With Us
    • Contact Us
    • Discussions
    Close search

    Activity › Forums › Salesforce® Discussions › How to Filter empty date field in SF analytics api?

    Tagged: Analytics API, Metadata, Multiple Records, Salesforce Error, Salesforce Wave Analytics, Summer 14, Syntax, Wave Analytics

    • Salesforce® Discussions

      How to Filter empty date field in SF analytics api?

      Posted by Nitish on April 30, 2016 at 4:49 PM

      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?

      Surbhi replied 9 years, 7 months ago 2 Members · 1 Reply
      • Analytics API
      • Metadata
      • Multiple Records
      • Salesforce Error
      • Salesforce Wave Analytics
      • Summer 14
      • Syntax
      • Wave Analytics
    • 1 Reply
    • Surbhi

      Member
      June 16, 2016 at 7:09 AM

      Hi Nitish,

      Are you still facing this issue ?

      Thanks

    Log In to reply.

    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me

    application solution

    Popular Salesforce Blogs

    Showcasing the Salesforce Ecosystem

    Blog in Salesforce Ecosystem

    Managing the Company Information with Salesforce Provides the Ultimate Support. Salesforce provides the website visitors, clients, managers, and service agents the required platform that acts…

    CRM, Customer Relationship Management, Internal Feedback App, Sales cloud of Salesforce, Salesforce Administrator
    William Jan 29, 2019
    3,269  Views
    Non-profit Business

    5 Ways to Speed Up Your Non-profit Business | Salesforce Guide

    Blog in Salesforce

    Mission, communication, and motivation are the three pillars of success for non-profit organizations. According to NonProfitPRO, these three steps help charities achieve their goals.  First,…

    Building Relationships, Business Flexibility, Business Operations, Client Testimonials, community
    CRMJetty Jun 16, 2021
    3,608  Views

    6 Best Practices While Implementing Salesforce Sales Cloud

    Blog in Sales, Salesforce Cloud Platform

    Sales Cloud is one of the most prominent offerings in the Salesforce ecosystem and has a proven track record of transforming the sales pipeline and…

    API, AppExchange Apps, Automated Workflows, Built-in APIs, Business Needs
    Carol May 6, 2022
    5,114  Views

    Popular Salesforce Videos

    Salesforce Interview Questions and Answers | 70 Salesforce Interview Questions for the Beginners

    Salesforce Interview Questions and Answers | 70 Salesforce Interview Questions for the Beginners

    Video in Salesforce Training

    In this video, Interesting data explains 70 Salesforce Interview Questions for Beginners. All the interview questions have been divided into the following important areas of…

    Salesforce Training, Salesforce Tutorial, salesforce, Salesforce Learning, Salesforce Interview Questions
    Rahul kapoor Dec 28, 2022
    1,733  Views
    Accenture Salesforce Training 2022

    Accenture Salesforce Training 2022

    Video in Salesforce Training

    This video is about -Accenture Salesforce Training 2022 Orientation session and ASE SFDC Salesforce Certification. As the trusted leader in Salesforce implementation and transformation, Accenture can…

    Salesforce Training, Salesforce Certification, Salesforce Developer, Salesforce Implementation, Salesforce Video
    Rahul kapoor Aug 12, 2022
    2,298  Views
    Invoke a Salesforce function from Apex

    Invoke a Salesforce function from Apex

    Video in Salesforce Training

    Learn about the different ways in which you can invoke a Salesforce. Watch this video and learn, if you have any doubts or concerns, do…

    Salesforce Training, Salesforce Tutorial, Salesforce Apex, Apex, Salesforce Learning
    Pooja Jun 10, 2022
    1,642  Views
    Footer Forcetalks logo

    support@forcetalks.com

    • twitterx

    Quick Links

    Advertise with Us

    Salesforce® Articles

    Dreamforce 2023

    Top Salesforce® Bloggers 2023

    Top Salesforce Consultants

    Get Listed

    Company

    Contact Us

    About Us

    Privacy Policy

    Terms & Conditions

    InsightHub

    Salesforce Blogs

    Salesforce Videos

    Salesforce Groups

    Salesforce Jobs

    © 2026 - Forcetalks ● All Rights Reserved

    Salesforce® is a trademark of Salesforce® Inc. No claim is made to the exclusive right to use “Salesforce”. Any services offered within the Forcetalks website/app are not sponsored or endorsed by Salesforce®.

    Try AuditMyCRM - It is a Salesforce CRM Audit tool which comprehensively scans your Salesforce org and gives you the list of errors or warnings you need to take care of.
    We use cookies to enhance your browsing experience. Please see our privacy policy if you'd like more information on our use of cookies.