Much depends on the structure of your data. But a script can use Get ( CurrentDate ) to find records with today's date.
See this thread for a number of examples of scripted finds: Scripted Find Examples
Date range finds can find records for a specified week, month, quarter or year.
The examples are a big help and it works.
One problem now is by running the script to filter by current date, the sub-summary by account # is ignored. Any way to keep the sub-summary by account number and filter just the current date records?
Sub summary layout parts are only visible if the found set of records are sorted in a sort order that includes the "when sorted by" field specified for the layout part.
Finds produce an unsorted found set so your sub summary layout parts will not be visible until you sort your records. But the same script that finds the records can also sort the records so as to keep your sub summary layout part visible.
Advanced reporting trick:
Since sub summary layout parts are only visible when their break (Sorted by) field is included in the sort order, you can use one layout to produce a variety of differnt report formats just by using different sort orders to group your records differently and control which sub summary parts are visible for a given report.
Thanks again Phil!