DATAIR Home Page
Knowledge Base
 Article DKB00071
DATAIR Knowledge Base Article DKB00071
Category: Pension System Data Import
Date Added:
1/1/2002 Last Edited: 1/1/2002

New Search | Back to Search Results | Print

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
Go To Top Of Page