>>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
>
Thank you, Fabio. I like this type of a "one-line" function, very cool.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham