Version 16 & Dates

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Version 16 & Dates

DKUKEC
Recently I switched over to version 16 and have discovered a couple of
issues.  This is one I thought I would share with the list and see if
anyone has a suggested solution.

My dataset includes dates that are string (mm/dd/yyyy).  I convert
these string variables into date variables by running the wizard and
the following syntax to create dd-mmm-yyyy.


* Date and Time Wizard: BirthDate.
COMPUTE BirthDateR = number(BirthDate, ADATE10).
VARIABLE LABEL BirthDateR "Date of Birth (SPSS)".
VARIABLE LEVEL BirthDateR (SCALE).
FORMATS BirthDateR (DATE11).
VARIABLE WIDTH BirthDateR(11).
EXECUTE.


When I use the same dataset and run a frequency in V15 of the date,
the output looks like dd-mm-yyyy; however, in V16, the output is
different (i.e., yyyy-mm-ddT00:00:00.000).  I have tried to correct
this by adjusting the cell format in the pivot table view; however,
that has not solved the problem.  I should note that in dataview
(V16), the data are displayed as dd-mmm-yyyy.  Any suggestions would
be helpful.


Thanks,
Damir

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD