InfoQube IM - Community

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)

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

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.

[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