Loading

How to Filter Salesforce Data by Date Field with Custom SQL

Publish Date: Apr 13, 2024
Task

How can we filter Salesforce data by a date field with custom SQL?

Steps
When connecting to Salesforce data with custom SQL, you need to write a SOQL compliant query. You can specify date values or date literals in the WHERE clauses to filter SOQL query results referring to Date Formats and Date Literals in WHERE.

Example:

SELECT
    CaseNumber,
    CreatedDate
FROM Case
WHERE CreatedDate > 2023-01-01T00:00:00Z
 
Additional Resources
For more information on the Salesforce Object Query Language (SOQL), view Salesforce Help.

Connect to a Custom SQL Query in Tableau

 
Knowledge Article Number

001498738

 
Loading
Salesforce Help | Article