Re: Date function within QUERY definition...

I thank you all for your input.  I finally resolved my date problem.  Try Try 
again, using your suggested code, got the job done.  I"m working with history 
of customer order changes & now that I could get days to work, 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
+---