>>>Hi,
>>>
>>>VFP 9 has a nice function Week() (determines week by the date). I cannot find in Help and maybe I am missing it, if there is a revers function, to determine date defining the week by the week number? For example, if the Week() is used as follows:
>>>
>>>nWeek = Week( date(), 3, 2 )
>>>
>>>Then I would use the reverse function as:
>>>
>>>dMonday = WDate( nWeek, 3, 2 )
>>>
>>>
>>>Of course, I could write such a function (WDate()) but it VFP has it, why not use it.
>>>
>>>TIA
>>
>>No, there AFAIK is no such native function.
>
>Thank you.
This will only return todays date unless you specify which day-of-the-week you want the date for. 41 is the week number.
DATE(YEAR(DATE()),1,1)+(7-DOW(DATE(YEAR(DATE()),1,1)))-6+(41*7)