Hi,
I've a date field in my application which has the dates from 1/1/2019 till 12/31/2021. Now if I create a Week(Datefield) the week number will be from 1 to 53.
So my requirement is if user selects year 2019 Week numbers has to be from 1 to 53, if User selects year 2020 Week numbers has to be from 1 to 53 and if User selects year 2021 Week numbers has to be from 1 to 43 where it has to restrict to load until Week 43 for current year and next week it has to load data until Week 44 because next week number is 44.
Any idea how to achieve it?