-
How to use Datetime in Dynamic SOQL Query in Salesforce?
While creating Dynamic SOQL, which involves Datetime gives ” no viable alternative at character ‘<EOF>’ ” error.
OR
value of filter criterion for field ‘CreatedDate’ must be of type dateTime and should not be enclosed in quotes
OR
How to use Datetime in Dynamic SOQL Query in Salesforce? -
1 Reply
-
This error is because of wrong construction of Dynamic Query with Datetime. following code snippet will give idea on how to construct dynamic query for Datetime ?
//format the datetime to make it Dynamic Soql ready
String formatedDt = cutOffDateTime.format('yyyy-MM-dd'T'HH:mm:ss'Z'');
String sql = 'SELECT a.Id FROM Agents_Answer__c a WHERE a.Agents_Test_Result__r.Agent_Name__r.IsActive__c = false AND LastModifiedDate < '+ formatedDt ;
Where, “cutOffDateTime” is variable of datetime type.
Log In to reply.
Popular Salesforce Blogs
The Top Five Nonprofit Agendas and Challenges | Salesforce Nonprofit
While technology and platforms continue to evolve, rules often limit marketers. Meanwhile, the nonprofit industry is addressing hurdles such as rising disasters and community needs,…
Salesforce Application Testing: Strategies, Best Practices, and Essential Tools
In software development, Salesforce is a cornerstone for customer relationship management solutions. However, ensuring these applications run smoothly and efficiently demands rigorous performance testing. This…
How Does Salesforce Revenue Cloud Benefit Sales and E-Commerce Businesses?
As Sales and E-Commerce business channels are affected by the ongoing pandemic, the generated revenue and customer demands are also deteriorating at an equal pace.…
Popular Salesforce Videos
Using Salesforce Einstein Prediction Builder
Make meaningful business predictions from your Salesforce data with just a few clicks, then use those predictions to make smarter business decisions and to power…
How To Use Journey Builder In Salesforce Marketing Cloud | Salesforce Tutorial
How to use Journey Builder in Marketing Cloud. This video will cover the following points - 1. Introduction Get a brief introduction to Journey Builder…
AMPscript Personalised Subject Lines in Salesforce Marketing Cloud
Cameron Robert from Datarati demonstrates how to use Subscriber Data and AMPscript to personalize your email Subject Lines in Salesforce Marketing Cloud. What you'll learn:…
