-
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
Steps to Send a Marketing Cloud Email by using Triggered Sends in Sales Cloud
Steps to send a Marketing cloud Email by using Triggered send in sales cloud Note - First you have to enable the Triggered send in…
APEX Rest Callout in Salesforce Integration
The Salesforce REST API allows you to integrate with Salesforce applications by using standard HTTP methods such as GET, POST, PUT, PATCH, DELETE, and HEAD.…
Stripe Integration with Salesforce
So firstly what is a stripe? Stripe is the most commonly used payment gateway. Stripe is widely used by e-commerce, subscription-based services, and by many…
Popular Salesforce Videos
Heroku | Salesforce Development Course
Knowledge of Heroku is also required to crack the Salesforce PD 1 Certification Examination. Let’s understand what Heroku is and what are its uses, in…
Build a Discount Calculator | Trailhead - Autolaunched Flow Salesforce Example
In this video, I'm creating a Discount Calculator with the help of Salesforce Flow to Automate Your Business Processes with Lightning Flow. So it's a…
How to Edit or Change Product Schedules in Salesforce
Use product schedules to determine the payment and delivery cycles for products that are paid or delivered over time. In Lightning Experience, customize schedules with…