=========================================================================
Date:         Mon, 31 Jul 2006 14:37:11 -0700
Reply-To:     "D.R. Wahlgren" <dwahlgren@projects.sdsu.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "D.R. Wahlgren" <dwahlgren@projects.sdsu.edu>
Subject:      Selecting by date
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

Gang,
I imported data from Excel into SPSS (Mac v 11.0.4).  I would like to
select a subset of cases based on values in a date format variable
(collecti) on or after April 21 of this year.

I have tried:

SELECT IF(collecti >= (YRMODA(2006,4,21))).

and

SELECT IF(collecti >= (21-APR-2006)).

The former runs but does not actually select any cases.  The latter
does not run but gives an error message.  I've looked at the "Date
and Time Functions" page in the help file but it is just too cryptic
for me to make heads or tails of.

Any advice appreciated.
thanks!
_dennis
--

```````````''''''''''''
Dennis R. Wahlgren, M.A.

Center for Behavioral Epidemiology and Community Health
San Diego State University
http://www.cbeach.org


"Poets say science takes away from the beauty of the stars--mere
globs of gas atoms.  Nothing is 'mere.'  I too can see the stars on a
desert night, and feel them.  But do I see less or more?"