Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

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

« Back to Tech Notes

AccuZIP's customer service is great. It keeps us from having down time and I'm always able to get a quick answer. don't have to worry about the size of the order I'm working with a client on. Most times, AccuZIP employees know more than the USPS employees. I've been able to navigate the lack of government employee training, which saves time, money and headaches.
M.L., Lansing, WV