I found a solution for what I wanted to do by using

SELECT 'ReportName_' + REPLACE(CONVERT(VARCHAR(10),GETDATE(),101),'/','') AS [FileName]

This then allowed me to proceed to step 4 where I could populate the necessary options for the fileshare csv file