6 Replies Latest reply: Apr 15, 2016 5:24 AM by Peter Cammaert RSS

    How to determine fiscal month using today's date?

    Xia Wang

      Hi, I am new to Qlikview and just went through developer training last week, so I am still practicing what I learnt from class. Our company has a 4-4-5 fiscal calendar as shown below. I was trying to determine fiscal month using today's date but not being successful. Can anyone please help me out on this one? For example, today is 4/14/2016, I'd like the application to return 'April' or '4'. Thank you in advance!

       

         

      MonthFromTo
      January12/14/20151/17/2016
      February1/18/20162/14/2016
      March2/15/20163/13/2016
      April3/14/20164/17/2016
      May4/18/20165/15/2016
      June5/16/20166/12/2016
      July6/13/20167/17/2016
      August7/18/20168/14/2016
      September8/15/20169/11/2016
      October9/12/201610/16/2016
      November10/17/201611/13/2016
      December11/14/201612/11/2016