Tag: soql

[Salesforce] Value of filter criterion for field ‘CreatedDate’ must be of type dateTime and should not be enclosed in quotes

September 7th, 2023
Reading Time: 2 minutes
To filter records by date in SOQL (Salesforce Object Query Language), you can use the comparison operators such as “=”, “<“, “<=”, “>”, “>=”, and “!=”. However a common mistake we made is to enclose the date with quotes like the following query:
```
SELECT Id, Name FROM Account WHERE CreatedDate < '2023-09-03' LIMIT 10
```
As soon as you execute it, you get this error:
```
INVALID_FIELD: 
SELECT Id, Name FROM Account WHERE CreatedDate < '2023-09-03' LIMIT
                                   ^
ERROR at Row:1:Column:36
value of filter criterion for field 'CreatedDate' must be of type dateTime and should not be enclosed in quotes
```
However if we remove the quotes we will get the same error
```
SELECT Id, Name FROM Account WHERE CreatedDate < 2023-09-03 LIMIT 10
```
To resolve the error “value of filter criterion for field ‘CreatedDate’ must be of type dateTime and should not be enclosed in quotes” in Salesforce, you need to make the following adjustments to your SOQL query:
1. Remove the single quotes around the date value.
2. Use the correct format for the date value by appending the time ‘T23:59:59Z’ , ‘T00:00:00Z ‘ or the hour you need at the end.
By following these steps, your query will correctly compare the ‘CreatedDate’ field to the specified date and time, without encountering the type mismatch error so the right query will be:
```
SELECT Id, Name FROM Account WHERE CreatedDate < 2023-09-03T23:59:59Z LIMIT 10
```
Another example:
```
SELECT Id, Name FROM Account WHERE CreatedDate < 2023-09-03T00:00:00Z
```
In the above example, we are querying the Account object and filtering records where the CreatedDate is less than September 3, 2023, at 00:00:00 (midnight) UTC. You can modify the date and time values according to your specific requirements. Ensure that the date and time format follows the YYYY-MM-DDThh:mm:ssZ pattern, where T separates date and time, and Z indicates the timezone as UTC. Remember, using the correct date and time format is essential in SOQL to accurately filter out records based on dates.
How can I query Accounts with at least one closed won Opportunity in Salesforce

February 13th, 2023
Reading Time: < 1 minute
In Salesforce, you can query accounts with at least one closed won opportunity by using a SOQL (Salesforce Object Query Language) query. Here’s an example of how you could write this query:
```
SELECT Id, Name, (SELECT Id, Name, StageName 
  FROM Opportunities 
  WHERE StageName='Closed Won') 
FROM Account
WHERE Id IN (SELECT AccountId FROM Opportunity 
  WHERE StageName='Closed Won')
LIMIT 10
```
This query returns all accounts that have at least one opportunity in the “Closed Won” stage. The inner query (SELECT Id, Name, StageName FROM Opportunities WHERE StageName='Closed Won') retrieves the closed won opportunities associated with each account, and the outer query (SELECT Id, Name, (...) FROM Account WHERE Id IN (...)) retrieves the account information for accounts with at least one closed won opportunity.

You can use this query in a number of different ways, such as in the Salesforce Developer Console, in Apex code, or in a tool such as the Workbench. Once you have the results, you can use them for further analysis, reporting, or to perform additional actions.
Get Accounts with at least one closed-won opportunity in Salesforce

January 29th, 2023
Reading Time: < 1 minute

Many companies use Salesforce to manage their business processes. One of the processes that Salesforce can help you with is tracking opportunities. You can use the platform to keep track of which leads or accounts have at least one closed-won opportunity. Knowing which accounts have won an opportunity can help your company target those companies for future sales or marketing efforts.
```
      
SELECT Id, Name,BillingCity, BillingState, BillingCountry, CreatedDate
FROM Account
WHERE Id IN (SELECT AccountId FROM Opportunity WHERE IsWon = true)
ORDER BY Name
LIMIT 10
      
    
```
Photo by Gwen Weustink on Unsplash

Tag: soql

[Salesforce] Value of filter criterion for field ‘CreatedDate’ must be of type dateTime and should not be enclosed in quotes

How can I query Accounts with at least one closed won Opportunity in Salesforce

Get Accounts with at least one closed-won opportunity in Salesforce