-
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
Why Need Salesforce Consulting Services For Your Business
Salesforce Consulting Services: Empowering Companies for Success during the Electronic Age In the present rapidly evolving enterprise landscape, harnessing the strength of technological know-how is…
Knowledge of Salesforce Flow and Different Type of Flows and Its Elements
What are Flows? In Salesforce, a flow is an application that automates complex business processes. Simply put, it collects data and then does something with…
Salesforce for Energy and Utility Sector for Adapting to New Customer Expectations
Energy and utility companies are known to have contingency plans to remain stable in any uncertain situation. And that’s where digitization has helped such companies…
Popular Salesforce Videos
Deleting Contacts in Salesforce Marketing Cloud
Delete contacts to remove contact information from your Marketing Cloud Contact Builder account. Delete contact information to meet data compliance regulations. In this episode, Eliot…
Introduction to Salesforce Flow Builder
Watch this video to learn about Salesforce Flow Builder. 0:00 Introduction 2:50 Introduction to Salesforce Flows 4:40 Types of flows, Screen, Auto-Launched 7:10 Components related…
Intro to Salesforce Macros
Users can run macros to complete repetitive tasks—selecting an email template, sending an email to a customer, updating the case status—all in a single click.…