Loading

How to Filter Salesforce Data by Date Field with Custom SQL

Date de publication: Apr 13, 2024
Tâche

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

Étapes
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
 
Ressources supplémentaires
For more information on the Salesforce Object Query Language (SOQL), view Salesforce Help.

Connect to a Custom SQL Query in Tableau

 
Numéro d’article de la base de connaissances

001498738

 
Chargement
Salesforce Help | Article