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 customer retention

    Effective Ways To Use Salesforce For Customer Retention

    Blog in AppExchange, Salesforce

    Why is Customer Retention Important? When techniques are implemented by way of sales groups to hold clients, revenue is going up and fees go down.…

    AppExchange Tools, Client Connections, Customer, Customer Data, Customer Experience
    Sumit kumar May 12, 2020
    3,511  Views
    Salesforce Consultation Partner

    How to Choose the Right Salesforce Consultation Partner for Your Business?

    Blog in Salesforce Consultant

    Salesforce consultation partners help businesses establish CRMs and other tech tools, so they perform seamlessly. The primary role here is to collect and maintain databases…

    Business, Business Consultants, Business Productivity, Businesses Measure, Client Satisfaction
    Melonleaf Sep 13, 2022
    2,409  Views

    No Code Clearbit and Salesforce Integration

    Blog in Salesforce integration

    Clearbit is a consumer contact marketing data engine. It assists businesses in expanding by delivering solutions that enable them to better understand their clients, discover…

    APIs, Applications, Business Operations, Clearbit, Clearbit and Salesforce Integration
    Apphienz Apr 7, 2022
    2,377  Views

    Popular Salesforce Videos

    Salesforce Admin Mock Interview Questions and Answers

    Salesforce Admin Mock Interview Questions and Answers

    Video in Salesforce Admin

    In this Salesforce Mock Interview Series, I'm dropping the seventh podcast/video of the Salesforce Admin Mock Interview Questions and Answers. This will help you to…

    Salesforce Training, Salesforce Tutorial, salesforce, Salesforce Community, Salesforce Admin
    Vivek Jul 8, 2022
    2,581  Views
    Google Home Assistant Integration with Salesforce

    Google Home Assistant Integration with Salesforce

    Video in Salesforce Integration

    Check out the below link for pdf view. https://www.linkedin.com/pulse/google-home-assistant-integration-salesforce-rajkiran-dewara/

    Salesforce Integration, salesforce, Salesforce Users, Google Home Assistant
    Rajkiran Jan 23, 2020
    4,570  Views
    Methods in Salesforce - All You Need to Know

    Methods in Salesforce - All You Need to Know

    Video in Salesforce Apex

    Learn All About Methods in Salesforce. Watch this video and do let us know if you have any doubts or concerns. What is a Method…

    Salesforce Training, Salesforce Tutorial, Salesforce Apex, salesforce, Apex
    SFDC Sep 16, 2022
    3,262  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.