Right now the file is being renamed with the current month (June), when it should be the previous month. Can anyone suggest how I would alter this code for the desired output? I tried F-1 but it didnt work, it said June 1 instead of the month before.
Code:
rename ("C:\Smurf_Reports\mssql\Monthly_Stats\monthly_mssql.csv", "C:\Smurf_Reports\mssql\Monthly_ Stats\old\monthly_mssql_" . date("m_Y") . ".csv");