Yes, you can do that using automation but Monarch alone isn't capable of that sort of thing. Data Pump for certain, but not Monarch.
It's pretty easy to accomplish with VBA or VBS, and should even be possible within a batch file solution, though I personally don't recall having done that (via batch file) before.
What are you using to automate your Monarch process?
Taken completely out of context from [URL="http://www.zorbathegeek.com/153/batch-file-to-append-date-to-file-name.html"]this site[/URL], I'd think that you're after a modification of this:
@For /F "tokens=1,2,3 delims=/ " %%A in ('Date /t') do @(
@For %%a in ("*.xls") do copy %%a "import\%%~na_%All%.csv"[/CODE]
Review the linked page for more information.
I see I'm late to the party again, you can use the following in a batch file to rename a file to the file name and date:
Example: REN C:\Temp\Temp.XLS TEMP_%DATE:4,2%%DATE:7,2%%DATE:~10,4%.XLS
If I'm not too late to the party...
As much of my analysis is done after overnight processing,
the end-user with reports & extracts for the current calendar date.
IF-THEN stmts could be used to skip weekends, etc, but the basic concept follows:
SET /A PREV=DAY - 1
Today's Date: %TODAY%
Yesterday's Date: %PREVDATE%