Re: Date function within QUERY definition...

["Gallagher, Debbie (CA - Toronto)" <dgallagher@xxxxxxxxxxx>]

Al:

I believe you will have to do it by selecting on before date or after date
equal zero. I never found a way to print only items that did or did not have
a ++++ result. Always had to figure out what made the +++ occur and select
based on that, as you are suggesting.

Debbie Gallagher
dgallagher@delolitte.ca

------------------------
Original message
------------------------
<snip> . . . , I created a field DAYS-AGO = how recently a change was made
relative to current date of printing the query, with default selection
criteria being all changes made in 
the last 7 days.

The only places with ++++ now are additions (old date non-existant) & 
deletions (new date non-existant) ... I want a report that excludes those 
cases & I could do it by excluding those with all zeros in before/after date

fields ... is there a way to exclude output that has a ++++ or ***** result?

Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor
-----------------------------------------------------------------------

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---