-
How can we use Datetime field as a criteria in SOQL Query in Salesforce?
How can we use Datetime field as a criteria in SOQL Query in Salesforce?
-
This discussion was modified 7 years, 1 month ago by
Prachi.
-
This discussion was modified 7 years, 1 month ago by Forcetalks.
-
This discussion was modified 7 years, 1 month ago by Forcetalks.
-
This discussion was modified 7 years, 1 month ago by
-
1 Reply
-
Hi Prachi,
We cannot use Datetime as condition in Where Clause in between single Quotes.
You can do something like this ,
WHERE CreatedDate > 2005-10-08T00:00:00Z
Or, you can also use Date Literals like
WHERE CreatedDate > YESTERDAY
Log In to reply.
Popular Salesforce Blogs
Salesforce Flow: A Guide to Automating Business Processes
Table of Contents Introduction Identify the Processes for Automation Map Out the Process Create Your Flow with Salesforce Define Elements and Logic Test Your Salesforce…
Objects Related To Salesforce Files And Connection Between Them
As we know most of the work has been shifted to Lightning Experience. The questions arise in the mind of users when Salesforce Classic provides…
Handle Your Cases Better With Algoworks Case Management App For Salesforce
Are you getting overworked with duplicate cases? Is your customer support team struggling with user dissatisfaction or high service cost? Are you finding it difficult…
Popular Salesforce Videos
Salesforce Winter '21 Highlights
Even in these unprecedented times when the world is struggling with a major pandemic that has brought everything to a standstill, Salesforce has strived hard…
Salesforce Flow to Create Feedback form on Case | How to use Slider, Radio button on Screen Flow
Use Case: In this video, we are creating a screen flow to get feedback from the users when the case is closed. Learnings: 1. How…
Real Time Synchronization between Salesforce and Quickbooks | eShopSync for Quickbooks
Now you can easily sync your data between Quickbooks and Salesforce through Real-Time Synchronization Feature, which allows you to import data from Salesforce to Quickbooks.…
