Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil_Kenth
Former Employee
Former Employee

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.

1 Reply
johnw
Champion III
Champion III

Maybe this?

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