Loading

Error "Invalid field formula due to limitations in the data source" Using Calculated Field as Extract Filter

Дата публикации: Feb 21, 2025
Описание
When you try to use a DATEPARSE() calculation as an extract filter, the following error occurs:

Invalid field formula due to limitations in the data source.
Unable to properly calculate the domain for the field '<Field Name>'. Displayed data may be incorrect.

Cause

Because extract filters send queries directly to the database, only functions supported by the data source can be used in a calculated field that is specified when creating an extract. 
Решение
When creating an extract, you can further limit the number of records extracted based on a specific field.  If this field contains a calculation, the calculation needs to use the DATE() function instead of the DATEPARSE() function. 
Номер статьи базы знаний

001473479

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