Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Custom Calendar Script

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

etc, etc.

Thanks in advance.

Tags (1)
1 Reply

Re: Custom Calendar Script

Maybe this?

date(monthstart(Date-25,1),'MMM YYYY') as Month

Community Browser