Loading

How to Filter Salesforce Data by Date Field with Custom SQL

Julkaisupäivä: Apr 13, 2024
Tehtävä

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

Vaiheet
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
 
Lisäresurssit
For more information on the Salesforce Object Query Language (SOQL), view Salesforce Help.

Connect to a Custom SQL Query in Tableau

 
Knowledge-artikkelin numero

001498738

 
Ladataan
Salesforce Help | Article