I need to get the Last Date for the last day of the previous month to add to a file name. Is there a way to do this in version 7?

Thank you,
Laurie

Category Survey AutoMate 7 version: 7.0.8 Windows version: Windows 7

Hi Laurie,

I couldn't find a super easy way to do this, but managed to get the date with a few steps.  Please see the attached task.

Category Survey AutoMate 7 version: Windows version:

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

Devin Cannon | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

Hi Laurie,

Using a VB function may accomplish this. Please see below.

Category Survey AutoMate 7 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)
<AMMESSAGEBOX>%DateSerial(Year(Date),Month(Date),0)%</AMMESSAGEBOX>

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

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

I tried to add this to the Rename File action and get an error: File and folder names cannot contain any of the following: /:"<>

Thoughts?

Thank you,
Laurie

Category Survey AutoMate 7 version: 7.0.8 Windows version: Windows 7

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMFILERENAME SOURCE="E:\Test\KSWIC_MAN_surg.txt" DEST="E:\Test\KSWIC_MAN_surg_%DateSerial(Year(Date),Month(Date),0)%.txt" />

Hello Laurie,

Since the expression results in a date format that uses the "/" symbol, Windows is informing us that it is not able to use it to name files.

That being the case, you will need to replace the "/" symbols with "_" for example. Here is a short example of how to accomplish this:

Category Survey AutoMate 7 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="var1" VALUE="" /> <AMVARIABLE NAME="var2">%DateSerial(Year(Date),Month(Date),0)%</AMVARIABLE> <AMMESSAGEBOX>%var2%</AMMESSAGEBOX> <AMREPLACE TEXT="%var2%" FIND="/" REPLACE="_" RESULTVARIABLE="var1" /> <AMMESSAGEBOX>%var1%</AMMESSAGEBOX>

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

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

...Alternatively, you can also use the format date/time action to accomplish the same (see code below).

You would then reference the variable at the end of the file name.

Let us know if these work for you.

Category Survey AutoMate 7 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="var1" VALUE="" /> <AMTEXTFORMATDATETIME DATETIMEFORMAT="mm_dd_yyyy" RESULTVARIABLE="var1" /> <AMMESSAGEBOX>%var1%</AMMESSAGEBOX>

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

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

Thank you! That will work great.

Laurie

Category Survey AutoMate 7 version: 7.0.8 Windows version: Windows 7