Submitted by jan_rifkinson on 2009/03/04 14:04
I have grid w:
 
item
DueDate
ApptDate
 
I want to filter for week or month for both date types in a single grid.
How do I accomplish this task?
 
Thank you.
 
--
Jan Rifkinson
Ridgefield CT USA

Comments

  • In the DateFilter toolbar, enter the list of fields (comma separated)
  • Select the = operator
  • Select your week / month or nbdays if you want a different time span
This will get you the list of items that have either one or the other.
 
If you want both to meet the criteria, you must use the filter on the Source bar, such as:
(DueDate ># 2001-01-01# AND  DueDate < #2002-12-31#) AND (ApptDate  ># 2001-01-01# AND  AptDate < #2002-12-31#)
 
I could improve the DateFilter toolbar and support an AND operator for fields. Would you like that?

jan_rifkinson

2009/03/04 15:32

Permalink

Pierre, as I remember the only two operands are = or <. There is no > I suppose there is a reason for this.  And altho I hadn't considered filtering as you suggest, there might certainly come a  time when I might so -- yes -- if it's not going to distract too much, that would be a good addition to the toolbox.  Thnx.
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1

Pierre_Admin

2009/03/04 15:36

Permalink

I didn't wait for your answer, the DateFilter toolbar now supports 2 field separators:
  1. , : ORs the fields
  2. +: ANDs the fields

jan_rifkinson

2009/03/04 15:40

Permalink

What too so long?
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1