I’ve been struggling to get the Monday from the week number and year number. Can anyone help? I would prefer that there is no reference made to 1900-01-01 because for 2022 the date that my query returns lands on a Saturday while the one for 2023 lands on a Sunday.

Here is the query I am using:

dateadd(week, weeknum - 1, dateadd(year, yearnum - 1900, '1900-01-01'))

Any help is appreciated.

Thanks

Output for example for year 2022 and week 50 should be December 12 ,2022