11 Replies Latest reply: May 15, 2016 12:38 AM by Prasanta Kumar RSS

    Master calendar

    Prasanta Kumar


      I am trying to create a master calendar which will help me to create a chart for a complete year even if i miss with data for a month.


      my month start from Nov of every year.


      and my order date column is in a format like "YYYYMM", for ex for nov'16 it is like 201611.


      can you please guide me how to create a master calendar for below information


      Fiscal year (format FY16)

      Fiscal Quarter (format Q1)

      month format (Nov)


      I have gone through some of the earlier post, but so far not able to achieve this.