Export as XLS with Date Stamp at end of file name

All things related to the Script feature of AccuZIP6, including the Script Monitor.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Export as XLS with Date Stamp at end of file name

Post by Eric » Fri Aug 22, 2008 12:08 pm

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
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply