View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Advanced Filter Issue

For some reason I can not get the criteria right for this...any help
mound be appreciated.

Field1 Field1 Field2
=12/31/05 <=3/31/06 =3/31/06


I am trying to filter all records in the between the two dates in
field1 AND the records must also have a date greater than field2.

It works perfect when I the criteria is on the 2 Field1 criteria but it
does nothing when I add Field2 to the criteria.

Ideas?