Hi rt

You can use Autofilter (custom) for this also
Record a macro when you do it.

Or use this Add-in
http://www.rondebruin.nl/easyfilter.htm
That have more options





--
Regards Ron de Bruin
http://www.rondebruin.nl


"rt" wrote in message ...
I want to create the vb code for an advanced filter type operation whereby I
filter between two dates. For example I want to filter for all birthdays
between 1/1/2004 and 5/1/2004.

I can't seem to get it to work. I understand the concept of the advanced
filter but no the logic for the whole date range thing

Thanks
j