1 Reply Latest reply: May 15, 2014 10:00 AM by Gareth Horton RSS

    naming of output files:

    Jay Dutta

      Hi: I am trying to save the data into an excel file but i would like to name the excel as

      FileName_[yyyy]_[mm-1].xls

       

      month has to be previous month number and not current month; can this be done in the xprj file output naming section? or some other way?

       

      please assist; i do not (yet) want to write a vbscript or other program to rename it.

       

      thanks a bunch in advance,

      Jay

        • naming of output files:
          Gareth Horton

          Jay,

           

          Todd has jumped the gun somewhat, as the functionality to which he is referring in not available in the current release of MDP.

           

          It will be available in MDP 8.5, free to those on maintenance.

           

          The new functionality is using Date Offsets with macros, which Todd has given you the syntax for.

           

           

          Gareth

           

          Originally posted by JAY DUTTA:

          Hi: I am trying to save the data into an excel file but i would like to name the excel as

          FileName_[yyyy]_[mm-1].xls

           

          month has to be previous month number and not current month; can this be done in the xprj file output naming section? or some other way?

           

          please assist; i do not (yet) want to write a vbscript or other program to rename it.

           

          thanks a bunch in advance,

          Jay /b[/quote]