Question
How can we filter Salesforce data by a date field with custom SQL?
Last Modified Date: 03 Oct 2023
Environment
- Tableau Desktop
- Salesforce.com
Answer
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 Information
For more information on the Salesforce Object Query Language (SOQL), view Salesforce Help.Connect to a Custom SQL Query in Tableau
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials