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.
Solution: set data loader option to GMT. After write date like this format:
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'
Thanks to all for the support!