Week number problem

Fri, 13 Sep 2013 07:05:49 GMT

Hi Please help me on this :

I want to get the ff week number of the days just like he ff:

Week 1 ( aug 1-3 )

Week 2 ( aug 4-10 )

Week 3 ( aug 11-17 )

Week 4 ( aug 18-24 )

Week 5 ( aug 25-31 )

However, this script which i am using : Ceil(Day(CreatedDate)/7)

Returns :

Week 1 ( aug 1-7)

Week 2 ( aug 8-14)

Week 3 ( aug 15-20)

Week 4 ( aug 21-28)

Week 5 ( aug 29-31)

I hope you can help me on this, thanks and more power!

Re: Week number problem

tresB — Fri, 13 Sep 2013 07:16:00 GMT

Please refer this post

tresB — Fri, 13 Sep 2013 07:38:03 GMT

Or,

directly try:

ceil((DateField-floor(weekend(monthstart(DateField))))/7)+1 as WeekOfMonth