Convert date

[Luis]

Hello.
I want to create a function that receives a week number and returns the date
of monday of that week.
For instance, if i send week number 34 to the function, the function should
return 16/Aug/2004.

Can anyone give me a hint?

Thanks
Luis

 

[Alex Dybenko]

First you have to find a monday of first week of ceratain year - you can get
weekday of january 1st and then plus or minus days
then you can add number of week to this "first monday" using function
dateadd()