1 Reply Latest reply: Sep 22, 2017 3:51 AM by Gysbert Wassenaar RSS

    Calculate Fiscal Year Flags on Master Calendar

    Michele De Nardi

      Hello experts,

      i want to add to my master calendar some fiscal year flags.

      My fiscal year start on month 7 (July) so i have to calculate a

      1) CurrentFiscalYearFlag so that each date between 01/07/2017 and 30/06/2018 is set to 1, otherwise 0.

      2) CurrentFiscalYearToMonthFlag so that each date between 01/07/2017 and the month of current date is set to 1, otherwise 0.

       

      If today is 22/09/2017 i want to obtain exactly this result:

       

      DateCurrentFiscalYearFlag
      CurrentFiscalYearToMonthFlag
      01/07/201711
      30/06/201810
      01/07/201800
      30/06/201700
      22/09/201711
      23/09/201711
      30/09/201711
      01/10/201710

       

      thanks