Paul’s Salesforce Blog

What’s new with Salesforce?

Correct format of a DateTime string in a SOQL statement

Posted by paulovery on June 29, 2015

Once in awhile I need to do a query against a DateTime string.  Since it’s so hard to remember the correct format, I decided to share it here.

Here is the correct format for a query with the DateTime included:

SELECT id FROM Account WHERE lastmodifieddate > 2015-05-20T00:00:00Z

Leave a comment