>>I have a DATE() to YYYYDDD function already but I received a file full of YYYYDDD instead of dates and need to get dates.
>>
>>Does anyone havce a quick algorithm/function already? Before I waste time reinventing the wheel.
>>
>>TIA
>
>How about
>
>

>** cDate - The YYYYDDD date
>LPARAMETER cDate
>nYear = VAL( LEFT(cDate,4) )
>nDay = VAL( RIGHT(cDate,3) )
>dStart = CTOD( "12/31/" + TRAN( nYear - 1) )
>RETURN dStart + nDay
>

>
>OTH

The current date format has to be MDY for this to work. Use DATE( ) instead to create nonambiguous Date values.