How to delete Negative months in Master Calendar

[madhubabum]

Hi all

I have the following Scenario ...

if(Year(tmp_Date)=WeekYear(tmp_Date), Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1,  Week(tmp_Date) + 52 - Week(MonthStart(tmp_Date)) + 1) AS [Week in Month], 

How can i delete Negative Months in master calendar.

Thanks

Madhu

[sunilkumarqv]

Try this

if(Year(tmp_Date)=WeekYear(tmp_Date), Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1,  Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1) AS [Week in Month],