6 Replies Latest reply: Oct 26, 2016 12:45 PM by Massimo Grossi RSS

    Literal Month Number

    Kyle Pillay

      Hi Guys

       

      Please could you assist me with the following:

      I have loaded a staffs start date and made end date to be September 2016.

      What i would like is for the literal number count to be applied based on the staffs start date month.

       

      For example:

      Staff A , started in December 2015 and end date is September 2016.

       

      I would like to display the counter as an expression as Start Month being 1 , second month being 2 and so on:

       

        Date Month      Counter

      Dec-151
      Jan-162
      Feb-163
      Mar-164
      Apr-165
      May-166
      Jun-167
      Jul-168
      Aug-169
      Sep-1610

       

      Thanks Guys!