Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Show Page Sections

download

ERROR at Row:1:Column:40

Error Message

This error message occurs because The Conga Query Builder leaves quotation ' marks ' around date fields.

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