Return date from week number and year

[peter smith]

I have a week number field and a year field (both numbers) and I would like them to return the date for the monday of that week.

Any suggestions

[BobWeaver]

Date(1;(Week-1)*7;Year)-DayOfWeek ( Date(1;1;Year) )+3

[-Queue-]

Case( weeknumber and year;

Date( 1; 1; year ) + 7 * (weeknumber - 1) - DayOfWeek(Date( 1; 1; year )) + 2

)

[-Queue-]

Ah, Bob beat me, but he inspired this 'simplification'.

Case( weeknumber and year;

Date( 1; 7 * weeknumber - DayOfWeek(Date( 1; 1; year )) - 4; year )

)

[peter smith]

sweet! thanks

[Ugo DI LUCA]

or...

week * 7 + Date(1; 1; year) - DayOfWeek(Date(1;1; year))-5