function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
EnryEnry 

Date time export data loader

I'm using the data loader to export accounts.

I put the following condition in the form of the dataloader:

Select NAME FROM Account WHERE LastModifiedDate = 2013-06-11T15:54:00Z

 But i'm not able to get the account that have lastmodifiedDate equals to 2013-06-11 time 15:54 ( these value are showed by an account).

I don't know which of the following parameters is important to have success:

 

--My user has: 

Time Zone (GMT+02:00) Central European Summer Time (Europe/Paris)

 

--Dataloader setting: timezone=Europe/Paris

 

 

--with a query in the developer console i see this format: 2013-05-31T12:26:35.000+0000

 

 

Please can you help me?

Which should be the right date format in the soql query?

Thank you in adavantage.

BR.

 

 

 

AroraAnupAroraAnup

My suggestion would be to put in a date range as the filter criteria instead of putting in an actual time. Here is an example that you can try out:

 

CreatedDate >2013-06-01T00:00:00.000Z && CreatedDate <2013-06-05T00:00:00.000Z

 

Let me know how it goes. Good luck!
KT1KT1

You can use what you have just make sure that you use this format: yyyy-mm-ddT00:00:00.000z. As long as you use that format it should work.
EnryEnry

Thanks! The solution:

Select id,account.owner.id,ownerid, LastModifiedDate FROM Contact WHERE LastModifiedDate >2013-06-13T09:30:00+02:00 and LastModifiedDate <2013-06-13T09:31:00+02:00 and LastModifiedById='005b0000000dbXm'