>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,
First of all, don't be embarrassed to show the code. No one's making judgments.
Unfortunately, a lot of people equate speed with the number of lines of code. Sometimes it's correct. Sometimes not.
Before responding, I'd ask two questions. What are the circumstances under which this function is being called? Are we talking about milliseconds or minutes with your function?
Remember, it's easy to offer advice in a vacuum. However, without specific details, it's hard to come up with an appropriate solution.
George
Ubi caritas et amor, deus ibi est