You need to sign in to do that
Don't have an account?
nikvm
how to use date in where clause SOQL ?
I am not getting the correct way putting date in below SOQL statement
SELECT id, CreatedDate FROM Sales_Order__c where CreatedDate < 2013-01-11
could some one help please
Thanks
error :
INVALID_FIELD:
recordtype__c FROM Sales_Order__c where CreatedDate < 2013-01-11
^
ERROR at Row:1:Column:877
value of filter criterion for field 'CreatedDate' must be of type dateTime and should not be enclosed in quotes
SELECT id, CreatedDate FROM Sales_Order__c where CreatedDate < 2013-05-21T00:00:00Z.
Mark as solution if you are able to fix your problem, so it would help others too.
Thanks,
Neetu Bansal
All Answers
SELECT id, CreatedDate FROM Sales_Order__c where CreatedDate < 2013-05-21T00:00:00Z.
Mark as solution if you are able to fix your problem, so it would help others too.
Thanks,
Neetu Bansal
SELECT Id FROM Donation_Allocation__c WHERE DAY_ONLY(CreatedDate) < 2013-01-11