Week Number & Year in different field - convert to Week Commencing

[#1]

Hi

I have two fields containing week numbers and year numbers.

How do i write an expression/formula to calculate a new field that will have a week commencing date?

Thanks

Simon

[swuehl]

Plase check the date and time functions in QV's HELP, namely

MakeWeekDate(YYYY [ , WW [ , D ] ] )

Returns a date calculated from the year YYYY, the week WW and the day-of-week D.

If no day-of-week is stated, 0 (Monday) is assumed.

Examples:

makeweekdate(1999,6,6) returns 1999-02-14

makeweekdate(1999,6) returns 1999-02-08

[#3]

Many Thanks - works fine !!