Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

This question already has an answer here:

The SF doc explains how to put a Datetime query in a SOQL query.

SELECT Id
FROM Account
WHERE CreatedDate > 2005-10-08T01:02:03Z

I need to just put in a date for this query. Something like:

SELECT Id
FROM Account
WHERE CreatedDate > 2005-10-08

But that throws an error. Any ideas?

share|improve this question

marked as duplicate by Ralph, Daniel Blackhall, eyescream, Saariko Feb 28 '13 at 8:40

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

add comment

3 Answers 3

up vote 3 down vote accepted

CreatedDate is a datetime field so I guess you would need to specify the time component.

Can you do something like where you just append the time portion to be 12 am by default.

WHERE CreatedDate > 2005-10-08T00:00:00Z

Or you can use Date Literals like

 WHERE CreatedDate > YESTERDAY

For more on date formats and more literal values see,

http://www.salesforce.com/us/developer/docs/soql_sosl/Content/sforce_api_calls_soql_select_dateformats.htm

share|improve this answer
add comment

If you want to avoid date manipulation with Apex, you could also create a custom date formula field and query off that field. Your formula would look like this:

DATEVALUE(CreatedDate)

Then just query off your custom field.

Let me know if you have any questions.

share|improve this answer
add comment

You'll want to use a DateTime and compute the range, or use date literals.

Date inputDate = Date.newInstance(2005,10,8);
DateTime refDate1 = DateTime.newInstance(inputDate.year(), inputDate.month(), inputDate.day(), 0, 0, 0);
DateTime refDate2 = refDate1.addDays(1);

List<Account> accounts = [
select id from Account
where createdDate >= :refDate1
and createdDate < :refDate2];

You can bind a date variable into the SOQL Query as well, but the results might not be what you expect.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.