InfoQube IM - Community

Submitted by jan_rifkinson on 2009/03/11 08:13

I don't understand:

In date filter operators are < or = but no >

or am I to assume the # of days functions as a >

= to March 3 for 10 days produces data from the 3rd to the 13th?

Did I crack the code?

Jan Rifkinson

Ridgefield CT USA

Comments

I could add the > operator to the datefilter toolbar. The other two are for:

=: to see appointments type info. You select a range (day, week, user-defined) and items meeting this range are displayed

<: to see todo type info. You select a range and all items which are due in that range or before are displayed. Use the CheckMark button to show/hide done items

What do you want the > operator to show? What application would you use it?

Hmmmmm.

I have both ApptDate & DueDate in one grid

On toolbar you showed me how to list my field criteria w a comma, i.e. ApptDate, DueDate

What I'm trying to figure out is how to avoid seeing past appts but still see items w DueDate that may have past (i.e.are still pending)

So to answer your question, I guess I would be using > in a formula of some kind to get a date range for appts based on today, ie, IQ show me today + upcoming appts for the week,etc plus all my ToDos which are still due up to the week, etc.

Does that makes sense?

I see I can choose today + x # of days going forward but in my case I think this clears due dates that have past that are still pending

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

It sure does make sense. Why not use the regular filter and use a criteria with "Now" such as:

done is null or (now- done < 5)

Try the To-Do's grid of a new file to see how it works

Thank you Pierre but may you could translate this for me, i.e.

now minus done less than five

Does this mean take today's date and show me items that are still pending from five days ago?

suppose i want all pending, not just 5 days....

With this in place, what happens to ApptDates that are past?

Do I mark past apptdates as done?

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

In the filter, you can try:

(ApptDate >= int(now) and ApptDate < now-7) or (DueDate < now and Done is null)

Translated: Show me all appts from today to a week from now and also show me all items that are due and not done

n.b. Don't forget to remove the datefilter

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

DueDate vs DateDue ?
Done vs DoneDate ?

basically, my example was generic. You need to change for your specific field names

got it. thanks

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1