When importing data from an Excel file, SPSS doesn't seem to handle
dates very well. I've found that the dates do not transfer correctly
(or not at all) with recent versions of Excel. The only one I've been
able to get to work consistently is Excel v. 3.0. But lately even this
has been failing. This could be because the original data file has the
dates formatting differently (i.e. mm-dd-yyyy and mm/dd/yyyy). I guess
I'll need to get that consistent before I worry about importing the file.
When I import the file the date fields are formatted as strings. If I
try to change this to date all the data disappears. Obviously, I'm doing
Thanks for any help.