Loading

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

Julkaisupäivä: Feb 21, 2025
Kuvaus
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. 
Ratkaisu
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. 
Knowledge-artikkelin numero

001473479

 
Ladataan
Salesforce Help | Article