-
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
Flow Builder and Approval Process in Salesforce
Flow Builder is the interface where Flows can be designed and tested. The below screenshot shows the Flow builder screen, and the following table explains…
Some Questions and Answers on Salesforce Pardot API
Have you ever wondered if, we can Query Pardot Engagement History in Salesforce by SOQL directly? Answer: No, Because The dataset "Pardot Engagement History" can…
Salesforce Financial Services Cloud – Why is it Worth the Hype?
Financial services corporations need to act faster on their customers’ needs by offering quick & robust solutions. And to help with that, the #1 CRM,…
Popular Salesforce Videos
Custom Aura Feed Component | forceChatter:feed | Chatter in #Salesforce | Salesforce Tutorials
In this vlog I will create a custom aura feed component with two picklists to select Group and then based on the Group selection, select…
Login Flow In Salesforce
You can use a login flow to customize the login experience and integrate business processes with Salesforce authentication. Common use cases include collecting and updating…
How Leadership Skills Helps to Shape Your Career? | Salesforce Learning
Leadership is an important skill to have because a good leader is able to bring out the best abilities in his/her team members and motivate…
