Read the rest of the article at artful software
" Here's an example: Compute date from year, week number and weekday SET @yr=2012, @wk=26, @day=0; SELECT Str_To_Date( Concat(@yr,'-',@wk,'-',If(@day=7,0,@day) ), '%Y-%U-%w' ) AS Date; "
post_ID = 1328