>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
Erik Moore
Clientelligence