>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.
CvtYYYYDDD2Date(tcYYYYDDD)
LOCAL nDays
nDays = VAL(SUBST(tcYYYYDDD,5))
RETURN EVAL('{^'+LEFT(tcYYYYDDD,4)+'-01-01}') + nDays - 1
>
>TIA