Bob What you could try is this proj ScoreStats fro blueview usi * whe appdate + is not null and (((imon(ssatdate)) >= 4) or ((imon(ssatdate2)) >= 4))
You could be receiving dates of Jan, Feb or Mar because all though imon of ssatdate2 >= 4 imon of ssatdate could be <= 3. I would say if you want to make sure you don't get Jan, Feb or Mar then replace 'or' with 'and' Buddy -----Original Message----- From: Bob Powell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: IMON Function 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? Thanks. Bob Powell ================================================ 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/ ================================================ 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/
