1 Reply Latest reply on Nov 22, 2016 5:09 PM by diego.medrano

    how to generate an event name based off a date field

    tom staab

      As an example, I have sales reports generated month and sometimes bi-monthly.  Instead of relying on the date stamp of the report, I would like name the reports Sales001 - Sales012.  Sometimes an additional report will be generated in the same month, so that would be Sales001b, etc.  The dates are always mm/dd/yyyy, so reports ran on 10/10/2016 and 10/31/2016 would be Sales010 and Sales010b.

       

      Any advice on a calculation for the above scenario?

       

      Thank you,

      Tom