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
sissyphussissyphus 

Date Help : Yesterday, Last Quarter, etc.

Hi all!
 
I heard from a little bird that SOQL allows you to specify dates using syntax that's something like "Today", "Yesterday", "Last week", "Last Quarter", "This Quarter", etc.
 
Does anyone have a reference or URL or any leads on where I can find the syntax for this? I checked the AppExchange API docs and they don't seem to have anything.
 
Thanks in advance for any leads on this!
Best Answer chosen by Admin (Salesforce Developers) 
SuperfellSuperfell
http://www.salesforce.com/us/developer/docs/api/index_CSH.htm#sforce_api_calls_soql_select_dateformats.htm