Hi all,
Addition to this
below link I got the week count as per db.
My current requirement is : I have week column coming from db. so I want to get the count of current week like week(today()) that is 36. and if the data is not available for current week it should show "0"
Example1:
weekNumber
36 ---10records
35 ---5 records
output:
current week as per calendar is 36 --- so it will give 10
last week as per calendar is 35 ----it will give 5
Example1:
weekNumber
36 ---10records
34 ---5 records
current week as per calendar is 36 --- so it will give 10
last week as per calendar is 35 so here 34 only there so it will give "0" as output.
Re: Need Week count