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

    Salesforce | Send a Marketing Cloud Email by using Triggered Sends in Sales Cloud

    Steps to Send a Marketing Cloud Email by using Triggered Sends in Sales Cloud

    Blog in Salesforce Cloud Platform, Salesforce Implementation, Salesforce Tutorial

    Steps to send a Marketing cloud Email by using Triggered send in sales cloud Note - First you have to enable the Triggered send in…

    Marketing Cloud Email, Sales Cloud Data, Salesforce Marketing Cloud, Salesforce Marketing Cloud Implementation, Salesforce Sales Cloud
    Rajan Apr 25, 2018
    15,367  Views
    Salesforce Trends 2021

    Salesforce Trends to Look Out for in 2021

    Blog in Salesforce

    Salesforce is one of the top Customer Relationship Management (CRM) platforms. It helps businesses to connect with customers and potential clients by using cloud technology.…

    Artificial Intelligence, Augmenting Marketing Campaigns, Automation Level, Best User Experience, Business Process
    Softweb Mar 25, 2021
    2,634  Views
    Salesforce Field Service

    Fillable PDFs for Salesforce Field Service

    Blog in Salesforce, Salesforce Stories

    Automating the generation and parsing of fillable PDFs in Salesforce Field Service can help you save time and eliminate human errors during data entry. Some…

    API Documentation, AssetId, Binary Data, Browser, Content Document IDs
    DB Mar 14, 2022
    2,924  Views

    Popular Salesforce Videos

    Add Sound Effects to Your Salesforce Org | Salesforce Tutorials | #SalesforceBolt

    Add Sound Effects to Your Salesforce Org | Salesforce Tutorials | #SalesforceBolt

    Video in Salesforce Development

    In this video you will learn to Use a Lightning Web Component to play a fun sound when a big deal closes. You can play…

    Salesforce Tutorial, Salesforce Development, Salesforce Developer, Salesforce Lightning, salesforce
    Kapil Jun 15, 2020
    5,196  Views
    How To Build a Kanban View Using LWC without APEX | Real-Time Project in LWC | Salesforce

    How To Build a Kanban View Using LWC without APEX | Real-Time Project in LWC | Salesforce

    Video in Lightning

    In this project, you will learn 60% of the LWC. You gonna learn the following topics 1. How to create a lightning Page 2. How…

    Salesforce Training, Salesforce Lightning, salesforce, Apex, Salesforce Video
    Nixalar JS Sep 11, 2020
    3,993  Views
    Salesforce Security and Sharing Model Demystified

    Salesforce Security and Sharing Model Demystified

    Video in Salesforce Security

    The Salesforce Sharing and Security Model has undergone numerous enhancements and offers many features to help you configure it to meet the privacy requirements your…

    Salesforce Security, Salesforce Sales Cloud, Salesforce Service Cloud, Salesforce Developer, Salesforce Apps
    Prafull Mar 22, 2018
    2,178  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.