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, 4 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

    Data Modelling

    All About Data Modelling in Salesforce

    Blog in Data, Salesforce

    In this blog, I am going to explain the topic of data modelling, fields, and object relationships. Let’s begin with:  Database It is an organized…

    Custom Field, Custom Objects, Data Modelling, Data Modelling in Salesforce, Database
    bhawana Nov 1, 2022
    2,568  Views
    Test Classes in Salesforce

    Test Classes in Salesforce - Learn All About it Here

    Blog in Salesforce Apex

    Content   What is a Test class in Salesforce?  What is the need of a Test class in Salesforce?  How to write Test class in Salesforce? …

    Apex Test Class, Assert Statement, Batch Class, Best Practices, Client Requirements
    ABHISHEK SHUKLA Jul 5, 2022
    3,152  Views
    Integrate QuickBooks

    How to Integrate QuickBooks and Salesforce?

    Blog in Salesforce integration

    Introduction QuickBooks, a leading accounting software platform developed and marketed by Intuit, a financial software development company helping businesses develop and sell financial, accounting, and…

    Apex Setting, App, AppExchnage, Applications in Appexchange, automated process
    Deepika Feb 17, 2021
    4,389  Views

    Popular Salesforce Videos

    What is a Salesforce PDO Partner?

    What is a Salesforce PDO Partner?

    Video in Salesforce Stories

    Salesforce market is growing very fast these years. It is estimated that in 2021 the Salesforce ecosystem will be worth around 100 billion U.S. dollars.…

    Salesforce Products, Salesforce Integration, Salesforce Partner, salesforce, Salesforce Ecosystem
    Algoworks May 18, 2021
    2,534  Views
    Benefit of User Centric Design (UCD)

    Benefit of User Centric Design (UCD)

    Video in Others

    User-Centric Design (UCD) puts people at the heart of product development, ensuring your interface, features, and user journey are built for real needs, not assumptions.…

    UX Design
    Dean Nov 25, 2025
    235  Views
    When to use which Sandbox? Salesforce Interview Questions and Answers

    When to use which Sandbox? Salesforce Interview Questions and Answers

    Video in Salesforce Admin

    Watch this video by CRS Info Solutions to when to use which Sandbox. Salesforce sandboxes are copies of your Production environment. A Sandbox contains all the…

    Salesforce Training, Salesforce Tutorial, Salesforce Online Training, Salesforce Admin, Salesforce Video
    CRS Dec 16, 2021
    2,796  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.