Bob, If ssatdate is > 4, but ssatdate2 <= 4, you will get those rows. If ssatdate2 is > 4, but satdate <= 4, you will get those rows.
Bill On Tue, 09 Jul 2002 12:46:03 -0400, Bob Powell wrote: >Hello Everyone, > >The following command should only get dates that have a month greater than 4 or April. > > > proj ScoreStats fro blueview usi * whe (appdate + > is not null and (imon(ssatdate)) > 4) or (appdate is not null and (imon(ssatdate2)) > 4) > >I still get January, February, March, and April dates. Any ideas as to why? > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
