search

datasert / realfire

Refreshing Salesforce Data Management
https://www.datasert.com
3 stars 2 forks source link

using datetime in soql select statements #8

Closed datasert closed 7 years ago

datasert commented 7 years ago

I can run this command in orher tools (Cloudingo Studio and FuseIT) but in Real Force it prompts me for values thinking the colons : in the datetime value are variables. I have tried making the value a variable with no success. Below is an example of a query that doesnt seem to work for me: SELECT Id, Name, RecordTypeid, CreatedDate FROM Account WHERE LastModifiedDate > 2015-04-06T21:40:32

datasert commented 7 years ago

If you turn off the bind variable detection, then soql should run fine. Btw, to run your exact query, you need to append Z to indicate the timezone. So this query runs fine in latest version.

SELECT Id, Name, RecordTypeid, CreatedDate FROM Account WHERE LastModifiedDate > 2015-04-06T21:40:32Z