Forums
Development
Salesforce
Use date fields in ...
 
Notifications
Clear all

[Solved] Use date fields in where clause in soql

 
Salesforce
Last Post by CWL 2 years ago
2 Posts
1 Users
0 Likes
266 Views
RSS
Posts: 205
 CWL
Admin
Issue starter
Aug 26, 2022 7:25 am
(@cwl)
Member
Joined: 11 years ago

How to use a date field in the where clause in soql?

Issue Tags
soql
1 Reply
Posts: 205
 CWL
Admin
Issue starter
Aug 26, 2022 7:28 am
(@cwl)
Member
Joined: 11 years ago

Date time is in yyyy-mm-dd and UTC time format. Example:

SELECT Id, CreatedDate FROM Sales_Order__c WHERE CreatedDate < 2013-05-21T00:00:00Z

Reference: Date Formats and Date Literals in WHERE Clauses | SOQL and SOSL Reference | Salesforce Developers

Reply
Forum Jump:
  Previous Issue
Next Issue  
Related Issues
Issue Tags:  soql (8) ,
Share: