I'm importing from an Excel spreadsheet that has been saved as a .WKS file, and dates on or after 01/01/2000 get imported as 1900. How can I fix this?
You need to make one change to the DIS file. In Data Import Assistant, on the Records and Fields screen, change the "Format" setting from "mm/dd/yy" to mm/dd/yyyy". This should solve your problem.
|
For more information about this or any other Knowledge Base
Article, please contact
[email protected] |
|
|
|
DATAIR Home Page
Article DKB00071