1 Reply Latest reply: Jan 9, 2014 10:04 AM by Friedrich Hofmann RSS

    Comparing FiscalYearDate to BillStartDate

    David Young

      I received help on my Master Calendar question earlier.  It will help but here is the issue I have:

       

      I have two dates in my table:

       

      FiscalYearBeginDate which could be 7/1/2012, 8/1/2012, 9/1/2012, etc.

      BillStartDate which could be any date so as an example lets say 2/1/2013

       

      What I need to know is the following:

       

      If FiscalYearBeginDate = 7/1/2012 then BillDate 2/1/2013 is Month 7 of Fiscal Year 2012, 8/1/2012 is Month 6 of Fiscal Year 2012, 9/1/2012 is Month 5 of Fiscal Year 2012, etc. 

       

      So for each BillStartDate I need to know which month and fiscal year that date falls into.  Does this make sense.

       

      David

        • Re: Comparing FiscalYearDate to BillStartDate
          Friedrich Hofmann

          Hi David,

           

          so, if I understand correctly, you just want an "alternative" master_calendar that starts with whatever date your fiscal year starts?

          Not sure how to do that.

          You could try using networkdays(), however, that would give you a nr. of days that elapsed since the beginning of the fiscal year up to the bill_date.

          HTH

           

          Best regards,

           

          DataNibbler