Custom MonthStart and MonthEnd

[#1]

Hi all,

I need to have custom monthstart and monthend Is this posible?

It completely depends on the week. Our week starts on Monday and ends on Sunday.

If the week starts on end of last month and ends on present month,  Then the monthstart date is that weekstart date for the current month.

And if monthend date will be checked on same basis it should be the last weekend date.

For example:

1)  October month : from sep 28th  to   Oct 25th.

2)  November month : from oct 26th  to Nov 29th.

3)  December month : from Nov 30th to Dec 27th.

Regards,

Pramod

[Anonymous]

Saturday and Sunday both?

or Sunday only?

[#3]

sunday only...

[Anonymous]

did you try this?

If(weekday(DateField)=6,'1','0') as SundayRecordCounter  //Define in script table

Take a text box with this expression =sum(SundayRecordCounter)

And select anything, it should work...

[#5]

My date field contains till today so i am getting only one sunday,

But i need without my datefield.

is any other suggestions?

[Anonymous]

Without DateField, I dont think so that it is possible