date problem again

[Raffe, Sydelle, SSA]

Now I need to create the following syntax (in a way that works of course).

        if (missing (apprv_dt) and missing (denialdt)) enddate = 31-JAN-2007.
        formats enddate (date11).
        exe.

SPSS doesn't complain, but neither does it fill in the value 31-JAN-2007. Thanks again for your help.

Sydelle Raffe, Alameda County Social Services Agency
Information Services Division
e:mail:  [hidden email]
phone: [phone]     fax: [phone]
If you have a request for information, please submit an ODM request form at:  https://alamedasocialservices.org/staff/support_services/statistics_and_reports/odm/index.cfm

[peter link]

Hi -

Try this...

if (missing (apprv_dt) and missing (denialdt)) enddate =
DATE.DMY(31,01,2007).
formats enddate (date11).
exe.

Peter Link
VA San Diego Healthcare System

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
Raffe, Sydelle, SSA
Sent: Thursday, March 01, 2007 3:51 PM
To: [hidden email]
Subject: date problem again


Now I need to create the following syntax (in a way that works of course).

        if (missing (apprv_dt) and missing (denialdt)) enddate =
31-JAN-2007.
        formats enddate (date11).
        exe.

SPSS doesn't complain, but neither does it fill in the value 31-JAN-2007.
Thanks again for your help.

Sydelle Raffe, Alameda County Social Services Agency
Information Services Division
e:mail:  [hidden email]
phone: [phone]     fax: [phone]
If you have a request for information, please submit an ODM request form at:
https://alamedasocialservices.org/staff/support_services/statistics_and_repo
rts/odm/index.cfm

[Raffe, Sydelle, SSA]

Bless you. I wonder if it will every sink in!

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
peter link
Sent: Thursday, March 01, 2007 4:18 PM
To: [hidden email]
Subject: Re: date problem again


Hi -

Try this...

if (missing (apprv_dt) and missing (denialdt)) enddate =
DATE.DMY(31,01,2007).
formats enddate (date11).
exe.

Peter Link
VA San Diego Healthcare System

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
Raffe, Sydelle, SSA
Sent: Thursday, March 01, 2007 3:51 PM
To: [hidden email]
Subject: date problem again


Now I need to create the following syntax (in a way that works of course).

        if (missing (apprv_dt) and missing (denialdt)) enddate =
31-JAN-2007.
        formats enddate (date11).
        exe.

SPSS doesn't complain, but neither does it fill in the value 31-JAN-2007.
Thanks again for your help.

Sydelle Raffe, Alameda County Social Services Agency
Information Services Division
e:mail:  [hidden email]
phone: [phone]     fax: [phone]
If you have a request for information, please submit an ODM request form at:
https://alamedasocialservices.org/staff/support_services/statistics_and_repo
rts/odm/index.cfm