Toggle Side Panel

  • Blogs
  • 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
  • Contact Us
  • Discussions
More options
    Sign in Sign up
    • Blogs
    • 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
    • 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 10 years, 2 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

    Popular Salesforce Blogs

    Review of Top 5 Free Salesforce Data Cleansing Tools [+ Salesforce Data Cleansing Best Practices]

    Blog in Salesforce Data integration

    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…

    API, AppExchange, Ascendix Search App for Salesforce, Automated Data Cleansing, Bad data
    Angie Sep 21, 2021
    3,286  Views

    Passing the Salesforce AI Specialist Certification with Dumpsforsure – Your Complete Success Guide

    Blog in Salesforce

    Introduction :  The Salesforce AI Specialist certification has quickly become one of the most valuable credentials for professionals working in artificial intelligence and CRM technology.…

    Angular2 in Salesforce, Campaigns In Salesforce, salesforcedeveloper
    Buskin Sep 22, 2025
    1,095  Views

    Outcome Management in Salesforce Nonprofit Cloud

    Blog in Salesforce Cloud Platform

    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…

    Actionable Relationship Center, Activities, App, ARC, Assessment Question Sets
    DB Nov 11, 2025
    280  Views

    Popular Salesforce Videos

    Salesforce CRM Full Training Tutorial For Beginners

    Salesforce CRM Full Training Tutorial For Beginners

    Video in Salesforce Training

    In this video, Nick Boardman explains how to use the key features inside Salesforce CRM. He explains various dashboard options, setting up campaigns etc.

    Salesforce Tutorial, salesforce, Salesforce CRM, Salesforce Learning, Tutorial
    Mayra Aug 17, 2022
    3,113  Views
    Introduction to Salesforce Nonprofit Cloud for Program Management

    Introduction to Salesforce Nonprofit Cloud for Program Management

    Video in Others, Salesforce Cloud Platform

    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…

    Salesforce Video, Salesforce Learning, Salesforce Nonprofit Cloud, Program Management, Nonprofit’s Mission
    Prafull Feb 4, 2021
    2,561  Views
    What Is Salesforce and Why Is It So Good?

    What Is Salesforce and Why Is It So Good?

    Video in Salesforce Stories

    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…

    Salesforce Development, salesforce, salesforce knowledge, CRM, Salesforce Developers
    Pooja Aug 7, 2020
    2,089  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®.

    We use cookies to enhance your browsing experience. Please see our privacy policy if you'd like more information on our use of cookies.