>Similar how VFP has function WEEK(), I need to find a reverse: Date (Monday) of the week by Week number (where Week Number is from 1 to 52).
>I actually have a function like that but it is so long I am embarrassed to show it here (it consists of 19 lines) <g>.
>
>I was wondering if anybody can recommend a short and fast (speed is the most important) function to do this.
>
>Thank you in advance.
try
FUNCTION WYTOD(nYear,nWeek)
RETURN DATE(m.nYear,1,1)-DOW(DATE(m.nYear,1,1),3) + m.nWeek*7