function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
aegirthaegirth 

Using a SOQL query with a DATE parameter

Hello

 

Is it possible for me to use a query like Date()-7 for a certain date/time field so the query returns values for the last 7 days?

 

Something like : 

 

select Id, OwnerId, dtDateDelivered__c from Service__c where dtDateDelivered__c < "TODAY()-7" ORDER BY dtDateDelivered__c LIMIT 10

 

Which doesn't work :)

 

 

Best Answer chosen by Admin (Salesforce Developers) 
SeAlVa_VFTabulatorSeAlVa_VFTabulator

Have a look at http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm

 

It would be something similar to this:

 

select Id, OwnerId, dtDateDelivered__c from Service__c where dtDateDelivered__c < LAST_WEEK ORDER BY dtDateDelivered__c LIMIT 10

 

If solved, please mark it.

Regards.

All Answers

bob_buzzardbob_buzzard

You can do this via a SOQL variable rather than a formula. Should be something like:

 

Date theDate=System.today().addDays(-7);

list<Service__c>=[select Id, OwnerId, dtDateDelivered__c from Service__c where dtDateDelivered__c < :theDate ORDER BY dtDateDelivered__c LIMIT 10];

 
SeAlVa_VFTabulatorSeAlVa_VFTabulator

Have a look at http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm

 

It would be something similar to this:

 

select Id, OwnerId, dtDateDelivered__c from Service__c where dtDateDelivered__c < LAST_WEEK ORDER BY dtDateDelivered__c LIMIT 10

 

If solved, please mark it.

Regards.

This was selected as the best answer
aegirthaegirth

This did it for me:

 

	select Id, OwnerId, dt_DateTimeClosed__c,dt_DateTimeOpened__c from OrderOverview__c where dt_DateTimeOpened__c = LAST_WEEK

 Solved.  Thanks guys!