Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
Enov Apps Hi,
I'm trying to export all accounts with lastmodifydate less than 01-03-2010 using the dataloader.
I want to export all possible fields, but everytime i get the same error (see below)
Does anyone know a solution for this?
http://i888.photobucket.com/albums/ac88/Enovation_Apps/ExportdataSalesforce.jpg
Hello, I recently received that error when I used non-SOQL date compliant format. Perhaps one of the below formats will help with your error?
Format Syntax Example
Date only:
YYYY-MM-DD
1999-01-01
Date, time, and time zone offset:
YYYY-MM-DDThh:mm:ss+hh:mm
1999-01-01T23:01:01+01:00
YYYY-MM-DDThh:mm:ss-hh:mm
1999-01-01T23:01:01-08:00
YYYY-MM-DDThh:mm:ssZ
1999-01-01T23:01:01Z
If it works, here is where I cut and pasted from:
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm
There is some good SOQL support available, just google to jump in. Good luck!
All Answers
Hello, I recently received that error when I used non-SOQL date compliant format. Perhaps one of the below formats will help with your error?
Format Syntax Example
Date only:
YYYY-MM-DD
1999-01-01
Date, time, and time zone offset:
YYYY-MM-DDThh:mm:ss+hh:mm
1999-01-01T23:01:01+01:00
YYYY-MM-DDThh:mm:ss-hh:mm
1999-01-01T23:01:01-08:00
YYYY-MM-DDThh:mm:ssZ
1999-01-01T23:01:01Z
If it works, here is where I cut and pasted from:
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm
There is some good SOQL support available, just google to jump in. Good luck!
Hi Minikramer,
Thanks for your answer. It worked after using the following format:
1999-01-01T23:01:01+01:00
YYYY-MM-DDThh:mm:ss+hh:mm