>>Hello,
>>I have two values, the Week (like 48 for today) and the year (1999).
>>How can I get the date of the first day of this week?
>>So it should give me the date of last Sunday.
>>I did not find any function for this.
>
>lnWeek = 48
>lnYear = 1999
>?(DATE(lnYear,1,1) + (lnWeek-1) * 7) - DOW(DATE(lnYear,1,1) + (lnWeek-1) * 7) + 1
Wow, this one really works!
The case Week=1, Year=2000 was really tricky, but this code solves the problem.
Thanks for your help.
Christian Isberner
Software Consultant