-
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 5 years, 7 months ago by
Prachi.
-
This discussion was modified 5 years, 7 months ago by
Forcetalks.
-
This discussion was modified 5 years, 7 months ago by Forcetalks.
-
This discussion was modified 5 years, 7 months 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
Top 5 Considerations in Choosing Your Salesforce CPQ Partner
Congratulations, you’ve made the decision to implement Salesforce CPQ! Now comes the challenging task of choosing the right Salesforce CPQ partner to help fulfill your vision…
Top 6 Benefits of Salesforce QuickBooks Integration
QuickBooks is an essential accounting application that many businesses trust today. It allows accounting professionals to record transactions with ease and accuracy. Whether you're billing…
Troubleshooting and Debugging Salesforce orgs in The Welkin Suite
Even though Salesforce has always been an innovative platform, just a couple years ago our troubleshooting options seemed as they were much more closer to…
Popular Salesforce Videos
Getting Started With The Ant Migration Tool in Salesforce
Ant Migration Tool In Salesforce. In this video, the following points will be covered - 1. Introduction Get a brief introduction about the Ant Migration…
Salesforce FY19 Year in Review
FY19 was our best year yet. With new partnerships and friends, we blazed new trails and continued creating a better future, together. Thank you to…
How To: Build A Salesforce Career with This Tool!
Timecodes 0:00 - Intro & Overview 0:57 - Talent Stacker 3:00 - Career Progression 10:08 - Flow is the Future 13:36 - Learn More/Outro If…
