>Hi all,
>
>Does anyone have a VFP WEEK() function emulator in FPD 2.x so that I don't have to reinvent the wheel? Thanks in advance.

This will do the basic WEEK() function with the default settings. You can add the other parameters and recalulate nOffset if you like. That's why I used nOffset, I just never added the FirstDayofWeek parameter.

FUNCTION Week
*: Description: Returns the week number of dDate
*:              Assumes Sunday is First Day of the week
*:
*:  Parameters: dDate - A valid FoxPro date.
*:**********************************************
PARAMETER dDate
PRIVATE dJan1, nOffset, nRetVal
    dJan1 = CTOD("01/01/"+ALLTRIM(STR(YEAR(dDate))))
    nOffset = DOW(dJan1)
    nRetVal = CEILING((nOffSet + (dDate - dJan1))/7)
Return nRetVal