You can try using Data Driven subscription for 'Windows File Share'. Create your SQL query for FileName field with appended date and use that field to specify the filename for your drop file.

For e.g.

SELECT CONVERT(VARCHAR(8), GETDATE(), 112) + '_YourFileName' AS [FileName];