Submitted by jan_rifkinson on 2009/03/13 08:26
((Pndg) or (FoloUp) or  (DateDue <int(now)+30)) and DateDone is null
 
It's supposed to mean:
 
1. all items w pending boolean = yes
2. all items w foloup boolean = yes
3. all items w assigned DateDue starting from today & going forward for the next 30 days and do not have DateDone assigned to them (i.e. are not completed or are still open)
 
I tried this using combo of regular filter + date filter but I couldn't make that work as it seemed date filter over rides source & plain filter
 
Thanks
 
--
Jan Rifkinson
Ridgefield CT USA

Comments

Is the filter by itself working (no datefilter)?
 
All filters (source, filter, alpha, date) are logically ANDed (so items must meet all filters to be displayed)

jan_rifkinson

2009/03/13 12:28

Permalink

That would explain the date filter.
 
I think I finally got it working with the following
((DateDue >=int(now) and DateDue <=int(now)+30) or Pndg or FoloUp) and DateDone is null
 
source = [datedue] or [foloup] or [pndg]
 
I don't dare think I'm beginning to understand this stuff but it seems to be working.  ;-)
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1

Pierre_Admin

2009/03/13 13:09

Permalink

I know for sure that soon you'll fully understand IQ... and that day, I'll hear you scream "NOW I Understand"    all the way from Ridgefield CT USA to here in Montréal, Qc, Canada
 
Have a great day, and keep plugging (and keep asking questions). Remember my offer for a free phone call. Many users have benefited from this offer to kick start their IQBase.

jan_rifkinson

2009/03/13 13:31

Permalink

[quote=Pierre_Admin]
I know for sure that soon you'll fully understand IQ... and that day, I'll hear you scream "NOW I Understand"    all the way from Ridgefield CT USA to here in Montréal, Qc, Canada [snip]
[/quote]
 
From your mouth to god's ear.
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1