Automation Designer doesn't provide this functionality, but as a workaround it's possible to rename the excel file and add yesterday's date in the file name and using a batch file in order to do this process automatically, that way the batch file can be invoked from Automation Designer and continue with the process.
WORKAROUND 1:
Once the job has been created in automation designer the next step is to create the batch file in order to be able to rename the excel file and add the yesterday's date to the file name.
Steps:
1. Open Notepad
2. Enter this code:
@echo off
@echo ---------- Adding yesterday's date to file name --------------
@echo off
set day=-1
echo >"%temp%\%~n0.vbs" s=DateAdd("d",%day%,now) : d=weekday(s)
echo>>"%temp%\%~n0.vbs" WScript.Echo year(s)^& right(100+month(s),2)^& right(100+day(s),2)
for /f %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "result=%%a"
del "%temp%\%~n0.vbs"
set "YYYY=%result:~0,4%"
set "MM=%result:~4,2%"
set "DD=%result:~6,2%"
set "date-yesterday=%yyyy%-%mm%-%dd%"
echo Yesterday was "%date-yesterday%"
rem --- you can copy the file and rename it at the same time or just rename it.
rem --- remove "rem" from the next line if you want only to copy the file. ---
rem copy C:\Users\ [user] \Downloads\testing\yesterday.xlsx C:\Users\ [user] \Downloads\testing\yesterday_%date-yesterday%.xlsx
rem -- remove "rem" from the next line if you want only to rename the file ---
rem -- ren yesterday.xlsx yesterday_%date:~-4,4%%date:~-7,2%%date:~-10,2%.xlsx
3. Save this code as add_date.bat
4. Add this file in Automation Designer, as the next steps after the export process.
--- In this example, the file is yesterday.xlsx, and it can be renamed for the file name desired.
