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