Discussion Board for collaboration on QlikView Scripting.
Does anyone have a custom calendar script that would set the starting day of each month to 26th of each month, for example:
January 2011 = 26th December 2010 - 25th January 2011
Fenruary 2011 = 26th January 2011- 25th February 2011
March 2011 = 26th February - 25th March 2011
Thanks in advance.
date(monthstart(Date-25,1),'MMM YYYY') as Month