Register

Setting up SYS Modules for Time Settings

neg177
Regular Contributor

Setting up SYS Modules for Time Settings

Hi,

 

What function would you use to display the numbered week in the Month, ex) the third week of the Month. 

2 REPLIES 2
ashish.banka
Regular Contributor

Re: Setting up SYS Modules for Time Settings

@neg177 You can use Previous() to get the week number for the month by referring a line item with a counter as 1 for each week.

 

Hope this helps

 

AB

rob_marshall
Moderator

Re: Setting up SYS Modules for Time Settings

@neg177 

 

@ashish.banka  is correct.  Another way of doing is using LAG: LAG(Week Numb Better + 1, 1, 1)

 

2020-10-26_15-03-41.png