[SalesForce] SOQL query to get records with start date in next 90 days

I'm trying to build a dynamic soql where a date field has to be in the next 90 days so the soql i wrote is as below , however this isn't working:

SELECT Id FROM X__c WHERE Start_Date__c = NEXT_90_DAYS.

Any help as to where I'm doing wrong?

Best Answer

It's because you're querying the objects with a date equals to the next 90 days.

Try this:

SELECT Id FROM X__c WHERE Start_Date__c <= NEXT_90_DAYS AND Start_Date__c > TODAY

Related Solutions

[SalesForce] SOQL query with Multi Select Picklist in where clause

SOQL reads String str = '\'Ann-OP\',\'Ann-RP\''; as a single Picklist value rather than two Picklist values Ann-Op and Ann-RP.

Try writing a dynamic SOQL query.

Example:

List<String> includesList = new List<String>{'\'Ann-OP\'','\'Ann-RP\''};
String queryString = 'SELECT Id, Name FROM Announcement__c  WHERE Public_groups__c INCLUDES(';
for(String includeValue :includesList)
    queryString += includeValue + ',';
queryString = queryString.removeEnd(',') +')';
List<Announcement__c> aL = (List<Announcement__c>)Database.query(queryString);

[SalesForce] SOQL query to return records with numeric values

As sfdcfox points out there isn't support for this natively in SOQL, however formula fields can in many cases be leveraged to do this type of work.

Creating a new formula field on the account object of type checkbox with a formula of ISNUMBER(Name) should get you a new boolean column you can filter on for this effect. As formula field values are generated on the fly during the query, much like SQL functions, this has a very similar result - it just has to be prepared ahead of time in a formula field instead of being embedded in the query at runtime.

Best Answer

Related Solutions

[SalesForce] SOQL query with Multi Select Picklist in where clause

[SalesForce] SOQL query to return records with numeric values

Related Topic