Month Start on 7th and Month End on 6th of every month............

[mohammadkhatimi]

Hi Everone,

My requirement is to Start month on 7th and Ends on 6th of every month...

For.e.g if I click on April-- Data should show from 7th of April till 6th of May...

I want to implement this on frontend...using set analysis...

Regards,

Mohammad

[swuehl]

Don't do this in frontend, do it a calendar you create in your script.

Maybe like

LOAD

     Date,

     if(Day(Date)>6, Date(monthstart(Date)+6), Date(monthstart(Date,-1)+6) ) as MonthStart,

     ...

[PrashantSangle]

Hi,

Try like

For

MonthStart

Date(MonthStart(Date)+6)

and

for MonthEnd

Date(MonthEnd(Date)+6)

Regards