8 Replies Latest reply: Jun 23, 2017 1:03 PM by Melissa Falardeau RSS

    Automator Export Naming - Need Next months month number

    Melissa Falardeau

      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