Skip to main content
Topics#Customer ServiceJack Spider's Question
Jack Spider asked in #Customer Service
Nov 6, 2014, 11:11 PM

Date Formats and Date Literals

I need to query the records created in the last two months.

 

I just checked the Salesforce Guide on Date

 

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

 

There are LAST_MONTH and LAST_N_DAYS

 

But I could not find an expression for LAST TWO MONTH.

 

Any suggestions?

 

 
2 answers
  1. Jack Spider
    Nov 7, 2014, 5:15 PM
    I got it work. 

     

    LAST_N_MONTHS:2
  2. Sunil Sarilla (M&G Investments)
    Nov 6, 2014, 11:25 PM
    Hi Jack,

     

    You can create a field filter

     

    Created Date equals Last 2 MONTHS and make sure the Range is All Time

     

    Please see the screenshot below

     

    Hi Jack, You can create a field filter Created Date equals Last 2 MONTHS and make sure the Range is All Time Please see the screenshot below

     

     
Write an answer...
0/9000