🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Automator Export Naming - Need Next months month number

User: "Melissa_21551"
Melissa_21551
New Altair Community Member
Updated by Melissa_21551

I have an automator export that I need to include a month in the naming of the xlsx export.  I currently have the export name as "Monthly PMI.&[mm].&[yy].xlsx"

 

So if it runs today the name would be Monthly PMI.06.17.xlsx

 

What I need is for the date in the name to include next month not the current month.  so: Monthly PMI.07.17.xlsx

 

Is there a macro I can use to achieve this?

 

 

Melissa Falardeau

Find more posts tagged with

English
Monarch
Quick Links