I suggest you should use the date and time wizard. It is found under compute. If you have a date variable you should be able to extract that day with any type of referential.

Richard Ristow <

[hidden email]> wrote: Last date of the month 5, or 11, or a chosen number of months from the

current one - Jim Marks posted a nice solution. Here's a variation

(code not tested):

At 12:47 PM 6/14/2006, Marks, Jim wrote:

>Here is a solution for 11 months out using SPSS date variables.

Still with SPSS date variables -

First, go *12* months out, instead of 11. That's not because 12 months

is a year; it's because 12 months is one more than you want:

*** month and year, adjusted for change of year (month gt 12).

COMPUTE month_12 =xdate.month(date)+12.

COMPUTE year_12 = xdate.year(date).

if month_12 GT 12 year_12 = year_12+1.

IF month_12 gt 12 month_12 = month_12-12.

(Of course, for exactly 12, the logic is easier, but I'm leaving it

general.)

Second, the 'cute' part: the last day of the month 11 months out, is

the day before the first day of the month 12 months out:

COMPUTE end_date = date.mdy(month_12,1,year_12)-TIME.DAYS(1).

Nadine Nana

404 805 6209

__________________________________________________

Do You Yahoo!?

Tired of spam? Yahoo! Mail has the best spam protection around

http://mail.yahoo.com