Skip to main content
Conga Support

ERROR at Row:1:Column:40 value of filter criterion for field 'CloseDate' must be of type date and should not be enclosed in quotes (Release 7)

CAUSE

The Conga Query Builder is a tool that helps you build SOQL queries. This error message occurs because The Conga Query Builder leaves quotation ' marks ' around date fields.

WHAT TO DO

Remove single or double quotation marks around dates from the generated query as shown below.

Change this:

SELECT Amount, Account.Name FROM Opportunity WHERE CloseDate > '2012-12-31'

To this:

SELECT Amount, Account.Name FROM Opportunity WHERE CloseDate > 2012-12-31