Week of year to date

[mikkom]

I have dates in database so that there is a year and a week of the year, for example 201029. And I need a formula that calculates first day of the week, for example 201029 -> 19-jul-2010 (monday). Is it possible to make a formula to do that?

 

[IanWaterman]

YOu can add weeks to 1st of year

@date
dateadd("ww", tonumber(right(datefield,2)), date(tonumber(left(datefield,4),01,01)

then determine day number to back calculate prior monday

@monday
dateadd("d", -(7-(Dayofweek(@date)))+1), @date)

Ian