Greetings - I'm working on cleaning up the code generated by the macro recorder for printing some reports, and I need to tell the report to print all rows where Column Q contains the words "Underwater Services" and Row "T" contains a date >= today.

Here's the code I have presently at that section of the sub-routine:

HTML Code: 
I've tried replacing the 10/22/2007 with date and today, but all I'm getting are reports with headers and no data. For what it's worth I don't really care about Columns "R" or "S" in the AutoFilter - I've got those columns hidden anyway.

If someone can offer suggestions that provide a cleaner way to filter on these two criteria and get the resuls described above I'd greatly appreciate it. Thanks in advance.

Marcus