I am trying to filter on a date.

Range("C8").AutoFilter Field:=3, Criteria1:="=10/08/2007 00:00",
Operator :=xlAnd, Criteria2:="<=13/08/2007 24:00"

( I got that from recoding a macro)

but that does not work from the code - some filtering is done but I get a
blank table (when I was reording the macro I was getting the correct results).

Any Idea? thanks

Dan