| Date: | Fri, 18 Jul 2003 10:36:18 -0500 |
|---|
| Reply-To: | "Marks, Jim" <Jim.Marks@lodgenet.com> |
|---|
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Marks, Jim" <Jim.Marks@lodgenet.com> |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
John:
It looks like your date string is mmddyyy. Try this:
DATA LIST /datestr (a8).
BEGIN DATA
02241964
12261960
01012003
END DATA.
STRING #date_0 (a10).
COMPUTE #date_0 EQ
CONCAT(SUBSTR(datestr,1,2),'/',SUBSTR(datestr,3,2),'/',
SUBSTR(datestr,5,4)).
COMPUTE date EQ NUMBER(#date_0,ADATE10).
FORMAT date (ADATE10).
EXECUTE.
Cheers
Jim Marks
Senior Market Analyst
LodgeNet Entertainment Corporation
-----Original Message-----
From: John Diez - Network & Online Services [mailto:JDiez@rnchq.org]
Sent: Friday, July 18, 2003 10:16 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject:
i have a date variable that is string. it looks like this "02241964". how do i convert it to a true date field?
|
