4 Replies Latest reply: May 2, 2016 4:29 PM by venkat sai RSS

    Create a Fiscal Calendar with non-standard dates

    Jamie Maguire

      Good morning,

      I've found a few discussions and blog posts which state how to create a Fiscal Calendar where they run from the beginning of the month to the end of the month, but I haven't yet found anything that can help me to solve my requirement, so I'm hoping someone can help me out.

       

      Our Fiscal Year runs from January 1st to December 31st, but each Fiscal Period ends on the last Friday of each month, with the exception of Period 12, which ends on December 31st.

       

      For 2015, this looks like the following (DD/MM):

       

      Period 1: 01/01- 30/01

      Period 2: 31/01 - 27/02

      Period 3: 28/02 - 27/03

      Period 4: 28/03 - 24/04

      Period 5: 25/04 - 29/05

      Period 6: 30/05 - 26/06

      Period 7: 27/06 - 31/07

      Period 8: 01/08 - 28/08

      Period 9: 29/08 - 25/09

      Period 10: 26/09 - 30/10

      Period 11: 31/10 - 27/11

      Period 12: 28/11 - 31/12

       

      Can anyone tell me how I can write a script that will automatically create the Fiscal periods for each year automatically?