Export as XLS with Date Stamp at end of file name
This command may be good for a script. In the command, it exports your data as a .xls file, and adds a date stamp to the name of the file. In the command below, the file is being being named TEST and saved in C:\
| COPY TO (FORCEEXT("c:\test"+ALLT(STR(YEAR(DATE())))+PADL(ALLT(STR(MONTH(DATE()))),2,"0")+PADL(ALLT(STR(DAY(DATE()))),2,"0"),"xls")) TYPE XLS |
