Advanced Filter Issue

M

michaelburkett

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
Click to expand...

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?
 
P

Peo Sjoblom

Do you have 2 date columns so that you want to filter the dates in one
column that is between Jan 1 AND Mar 31 AND the dates in a second column
that is greater than Mar 31. Then your criteria works.
It obviously won't work for one column of dates but for 2 yes it does work

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top