search

SFDCACE / excel-connector

Automatically exported from code.google.com/p/excel-connector
0 stars 0 forks source link

Value of date fields change from dd/mm to mm/dd (value not formatting) #7

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Describing Sforce object
2. Entering ID fields (or any relevant field)
3. Querying rows through the connector to retrieve information from 
Salesforce.com that contain dates fields where the day is 12 or less.

What is the expected output? What do you see instead?
Expected output 04/11/2010 - instead, 11/04/2010 - only applies to dates that 
are under the 12th of the month. Does not change formatting, changes actual 
value of output.

What version of the product are you using? On what operating system?  With
what Salesforce.com edition?
6.16pe, Microsoft XP Professional addition, with Salesforce Professional Edition

Please provide any additional information below.
This does not happen when a report is extracted in to Excel using Salesforce, 
only when retrieving the information through the connector.

Original issue reported on code.google.com by bsrhicks@gmail.com on 30 Nov 2010 at 10:11

GoogleCodeExporter commented 8 years ago 
This is a MAJOR issue with the connector - is it possible for a patch to fix it 
please?

Original comment by bsrhicks@gmail.com on 6 Dec 2010 at 4:59

GoogleCodeExporter commented 8 years ago 
What language setting do you use ?
Is this a date field or a date time field ?

can you try this with the updated PE version found on the Downloads tab, your 
version is older.  you may also need to update the office toolkit version, also 
found on downloads page

Original comment by vneh...@gmail.com on 11 Mar 2011 at 4:11

GoogleCodeExporter commented 8 years ago 
I am having the same issue. I am running Windows 7 with Office 2010, I have the 
new PE 11 version and have updated the Office Toolkit as well, but no 
difference. The problem seems to be with the Date format that is being used - 
date time instead of just date. Changing the filed format doesn't help either. 
I have seen the same issue on the developer.force board as well. I am in 
Germany but have Windows setup for English.

Any help would be appreciated!

Original comment by lrconsul...@googlemail.com on 23 Mar 2011 at 1:17

GoogleCodeExporter commented 8 years ago 
If this is specific to row queries refer issue 39

Original comment by mikeolg@gmail.com on 26 Jul 2011 at 8:22