Has anyone tried to do a data driven schedule?

For example, I have a client who decided that they want a report delivered on the first Tuesday of each fiscal month. I have the fiscal month start and end dates in a table and I wrote a query that will always return the date value for the first Tuesday of the fiscal month. Reporting services, however, does not natively allow for that type of schedule. Any ideas how to get the schedule to deliver on the date returned from a query?