calculate time settings with out hard coding


HI All,

I want achecive below attached scenario without hard code.

in source if i enter y the result should be start week and end week

start week can find out by current period () and how can i find out end week without adding +52 or 53

same applice to below scenario y-1


  • AjayM

    Hi @kishoreanimi ,

    You can use end() function along with the source input, to identify your desired end of specific year, without having to add 52 or 53. I considered source module dimensioned by YEAR, for the week number input. Hope the below gives an idea of how you can use the result in your case.