Data Type Literals

When using string literals in commands please adhere to the following formats:

DataType

Format

Example

DateTime

yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

2010-10-21T23:15:00.000Z

Date

yyyy-MM-dd

2012-12-31

MultiPickList

semi-colon-delimited values

Red;Blue;Green

General Limitations

UPDATE, DELETE and SELECT all depend on the SOQL WHERE clause, so they inherit the limitations provided by Salesforce. In particular you cannot write a WHERE clause that compares one column to another, eg: