How to restrict data to load until current week from date field
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.