Hi,

I am new to the automate world and need some assistance with a script that has already been created.  Basically the task connects to a drive and downloads the latest file within a folder.  I am trying to get the automate task to grab only the latest file which gets generated at this location every morning at 2am.

for instance todays file is named: 0001030.txt and the date changes every day.  Tomorrows will be 0001031.txt and next day should be 0001101.txt

How do I modify my task to look for this file?

Any help will be appreciated.

Thanks

Category Survey AutoMate 10 version: 10.4.2 Windows version: Windows Server 2012

Hi Yogesh,

You can use the Format Date and Time action to format today's date as you need it, in this case MMDD and store it in a variable. Then use that variable as part of a file copy or download action. The sample steps below illustrate how this can be done.

Category Survey AutoMate 10 version: Windows version:

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="varDate" VALUE="" /> <AMTEXT ACTIVITY="format_datetime" RESULTVARIABLE="varDate" DATETIMEFORMAT="MMdd" /> <AMFILESYSTEM SOURCE="\\Server\test\000%varDate%.txt" DEST="c:\test\*.*" />

-------------------------

Justin Aucoin | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665