Compute Date

[Vivek Kurup-2]

Hi all,

I have a variable which stores the number of days from Jan 1, 1980. How
do I compute the actual date from this variable, in the format:
DD-MMM-YYYY? For eg, for 28-sep-2006, the variable stores "9767"

Thanks,
Vivek

[Oliver, Richard]

Let's call the existing variable "dayvar":

Compute newdate=datesum(date.mdy(1,1,1980), dayvar, "days").
Formats newdate (adate10).

This is from memory and I didn't test it, since I'm in the middle of re-installing all my applications on a new computer.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Vivek Kurup
Sent: Monday, January 08, 2007 12:36 PM
To: [hidden email]
Subject: Compute Date

Hi all,

I have a variable which stores the number of days from Jan 1, 1980. How
do I compute the actual date from this variable, in the format:
DD-MMM-YYYY? For eg, for 28-sep-2006, the variable stores "9767"

Thanks,
Vivek