Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Or,
directly try:
ceil((DateField-floor(weekend(monthstart(DateField))))/7)+1 as WeekOfMonth
Please refer this post
Or,
directly try:
ceil((DateField-floor(weekend(monthstart(DateField))))/7)+1 as WeekOfMonth