[SalesForce] Date range on custom date field in SOQL Query

Is there a limitation that prevent filtering SOQL queries on custom date fields?

This query works;

SELECT Id FROM SomeObject__c WHERE CreatedDate >= 2012-12-27T00:00:00Z

This one;

SELECT Id FROM SomeObject__c WHERE CustomDate__c >= 2012-12-27T00:00:00Z

Returns the error

value of filter criterion for field 'CustomDate__c ' must be of
type date and should not be enclosed in quotes.

…I've double check that CustomDate__c is a date field.

Best Answer

Try this:

SELECT Id FROM SomeObject__c WHERE CustomDate__c >= 2012-12-27

and see if it works. If so, the Custom_Date__c field is Date, not Date/Time, and requires a different where statement to resolve.

Related Solutions

[SalesForce] Correct Date format for Developer Console Query Editor

Try:

SELECT Site__c, Cluster__c, Date__c, Num_Att_records__c 
FROM Session__c  
Where Session__c.SiteProgram__r.Name = 'Brattleboro' AND Date__c = 2012-11-06

Note the leading 0 on the 06.

The format is YYYY-MM-DD, so you need to pad the extra 0.

[SalesForce] How to filter on CreatedDate using a date range in SOQL

Date values are always interpreted as if they were from midnight in GMT or local time zone (depending on the method you use). Use a DateTime variable instead.

DateTime dateUntil = DateTime.parse('7/30/2020, 12:59 PM');

The exact format will depend on your locale; check the documentation for more information.

Or, you can use the newInstance method:

DateTime dateUntil = DateTime.newInstance(2020, 7, 30, 23, 59, 59);

There's a lot of ways to do this correctly, but you'll need to check the documentation. The number of possible options makes it really easy to do it incorrectly.

Best Answer

Related Solutions

[SalesForce] Correct Date format for Developer Console Query Editor

[SalesForce] How to filter on CreatedDate using a date range in SOQL

Related Topic