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

    Top 10 Salesforce Winter ’21 Features for Reimagining your Experience Cloud Journey

    Blog in Salesforce Cloud Platform

    As is the norm with all feature update releases, Salesforce’s Winter ’21 release is packed with features that add fluidity to workflows and help businesses achieve…

    Authentication Method, Businesses, Campaigns, Cases, Cloud Journey
    LevelShift (formerly DemandBlue) Oct 29, 2020
    5,690  Views

    How to Hire Salesforce CPQ Developer for Business Success

    Blog in Salesforce

    In the competitive world of B2B sales, speed and accuracy are the dual engines of growth. However, as product catalogs grow and pricing structures become…

    Hire Salesforce CPQ Developer, Salesforce CPQ Consulting Services, Salesforce CPQ Services
    Dean Mar 13, 2026
    353  Views

    Supercharge Support Agents with These Lesser-Known Salesforce Service Cloud Features

    Blog in Salesforce, Salesforce Cloud Platform

    We are living in a time when customer experience matters the most for a business. A disappointed customer will take no longer a minute to…

    Business, Case Resolution, Centralized Data, Customer, Customer Experience
    360 Degree May 9, 2022
    2,497  Views

    Popular Salesforce Videos

    Salesforce Admin Certification 2020 Questions Explained with References - Part I

    Salesforce Admin Certification 2020 Questions Explained with References - Part I

    Video in Salesforce Certifications

    How to prepare and pass Salesforce Admin Certification with Practice Exam Questions 2020 practice questions and answers for the Salesforce Administration Salesforce Certified Admin Exam…

    Salesforce Training, Salesforce Tutorial, Salesforce Administration, Salesforce Certification, Salesforce Admin
    Prafull Feb 26, 2021
    2,211  Views
    Welcome to the Partner Marketing Center | Salesforce

    Welcome to the Partner Marketing Center | Salesforce

    Video in Salesforce Products, Marketing

    The Partner Marketing Center (PMC) is your one-stop shop for customizable marketing assets. By logging into the PMC you can easily access, customize, and deploy…

    Salesforce Training, Salesforce Tutorial, Salesforce Partner, salesforce, Salesforce Video
    Pooja Apr 21, 2021
    2,613  Views
    Salesforce Admin Beginners Tutorial - 3.1 - Salesforce Platform Basics

    Salesforce Admin Beginners Tutorial - 3.1 - Salesforce Platform Basics

    Video in Salesforce Training

    Salesforce is an innovative tool that can be very powerful when used properly. That’s why it’s important to find effective and trustworthy ways to learn…

    Salesforce Tutorial, Salesforce Certification, Salesforce Administrator Training, Salesforce Administrator, salesforce platform
    Shiv Kumar Sharma Mar 8, 2018
    2,632  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.