Yeah, that's pretty much what I came up with. It fails on years where 1/1 is Thursday-Sunday, so I added an IIF to account for that.

I was hoping there was a function that did it already, but I guess not. :)

Thanks,

Michelle


>How about
>
>{1/1/2004}+5-dow({1/1/2004})+(29-1)*7
>
>>If I do:
>>
>>? WEEK({07/15/2004},1,5)
>>
>>I get 29. Is there any way to reverse this? If I have "2004" and "29" and know the week starts on day "5", is there any way to return {07/15/2004}?
>>
>>I looked through the help file, but didn't see anything helpful. :)
>>
>>This is for VFP 5.
>>
>>Thanks,
>>
>>Michelle