You can achieve it by creating a report first with the required query, and to include the date you can add it in Automatic response for email.
I've never read about using a variable in query sections though.
I have a lot of questions about what you propose:
- Automatic Response is triggerd by an event. How would you trigger it and what event would you use?
- How would you be able to include the report attachment into an Automatic Response e-mail message? AR is only capable of starting a Server task, but the server task itself is still running independent from the Automatic Response operation. Also, the e-mail functionality whithin the Server Task component does not support AR variables. (tested it)
- How does this include a date notation in the report file name?
Unless somebody can tell me it is possible to reach the aforementioned goal, I think ePO does not currently offer this functionality and if one should want to have it included, it will have be requested via PER and nobody knows how long that will take if ever...