Page 1 of 1

Export as XLS with Date Stamp at end of file name

Posted: Fri Aug 22, 2008 12:08 pm
by Eric
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:\

Code: Select all

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