-
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 6 years, 5 months ago by
Prachi.
-
This discussion was modified 6 years, 5 months ago by Forcetalks.
-
This discussion was modified 6 years, 5 months ago by Forcetalks.
-
This discussion was modified 6 years, 5 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
Artificial Intelligence vs Automation: Which is Better for Salesforce Deduplication?
While a lot of businesses are looking to streamline processes, this can be done in many different ways via automation, machine learning, and artificial intelligence.…
Expertise and Support: The Key Benefits of Choosing a Salesforce Partner Company - InfoDrive Solutions
Salesforce is a powerful platform that can help businesses streamline their operations, increase productivity, and improve customer relationships. However, implementing and managing Salesforce can be…
5 Real Business Advantages of Salesforce Integration
Businesses are linking systems, applications, and tools in order to improve their abilities and develop connected ecosystems. For linked structures, the old saying “the whole…
Popular Salesforce Videos
BradForce Interview with special guest Jason Jung | Landing Your First Salesforce Job
In this video, I have a great conversation with Jason Jung. Jason landed his first Salesforce Job in the middle of a global pandemic. Listen…
Salesforce Account-Based Marketing Demo
Salesforce Account-Based Marketing is a partnership aligning Marketing, Sales, and Service around a single view of your top accounts. A partnership which reesults in long…
Lesser Known VSCode Tips for Salesforce Developers
More Code, Less Work. Whether you are a beginner or an advanced developer, smart tips, and sharp tools can significantly improve your productivity. There are…
