Convert date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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()
 
Back
Top