>>>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
>>
>>ldNewDate = CTOD([01/01/] + LEFT(JulianField, 4)) + VAL(RIGHT(JulianField, 3)) - 1
>
>Warning. Only works with SET DATE AMERICAN! (or DMY)
Doh! That should be MDY, not DMY.