>>From Excel, a date field has been converted to a numeric value after the import.
>>
>>So, a date like 1/12/1999 could give a value like 35827. Some other fields gave something like 35957.50841435185. Is there a simple formula to reverse that to the date value?
>
>
>I have found that if the date was formatted 01/12/1999 (this is two digit month & day) in Excel it imported correctly.
I imported the file using the File Import option. I didn't use the Import Wizard. Maybe I should have used it. Could this be a factor?