I think pr2-eugin meant you can use the OutputTo command in a macro or VBA. If you follow the link you will see how the command is used. You can put the date into the file name a bit like
DoCmd.OutputTo(ObjectType, ObjectName, OutputFormat, "C:\reports\" & Date(), AutoStart, TemplateFile...