Loading

How to Filter Salesforce Data by Date Field with Custom SQL

Дата публикации: Apr 13, 2024
Задача

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

Действия
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
 
Дополнительные ресурсы
For more information on the Salesforce Object Query Language (SOQL), view Salesforce Help.

Connect to a Custom SQL Query in Tableau

 
Номер статьи базы знаний

001498738

 
Загрузка
Salesforce Help | Article