>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.
Dmitry,
It's not that hard to find the first monday of the year (date(year,1,1), find out the dow, and add a number depending on dow() to get to the first monday)
From there, add 7 * (weeknumber - 1)
Gregory