I want to be able to have an automated daily extract that accepts a date as a filter parameter.
You can define a range of dates to export relative to the current dates by means of SQL date-time functions or use parameters in queries.
You can define parameters prefixed with the colon character. You'll be prompted for their values before data export starts.
You can run a project from the command line to change parameter values on the fly. Or you can modify the export project for that.
The alternate way is to use COM automation, but that requires programming (demo projects can be found in the installation folder).