As per calender week

[soniasweety]

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

[Anil_Babu_Samineni]

You can manipulate in script like

Load ...., If(Week<> Week(Today()), '0', Week(Today())) from DB;