I am trying to import a few fields from an ORACLE table. I have imported the data before using ECW, but my problem in this excahnge is the date fields when I generate the XML file the date is formated as: 2002.05.01.12.00.00 instead of 05/01/02. My system settings are: Datetime format: Short Date, Short Time Date Format: 10/14/05 Time Format: Medium time
In the spreadsheet the cell format is Number : Date , Type 3/14/01 Not sure what am i missing any help would be appreciated.
Vasily- I tried to change the date format from the SD client - it didn't help the custom field is short date and in the option setting it is short date. Am I missing something ? your help is greatly appreciated
we had similar problems, I think there was a bug introduced in a particular service pack that made SD unhappy with the date fields. I have tried formatting the date in just about every way possible but to no avail, we are currently at SP10, I dont know if there is a hotfix available. Nick
In your spreadsheet, select the column which contains the date fields. Choose Data --> Text to Columns. Select delemited and choose next. Leave the 'tab' as the default delimitor and click next. In the COlumn data format, choose 'Text' and click on finish. Now save the excel file and try to do a data exchange again.