Julian to Gregorain dates

[Reid_at_work]

Hi
I am trying to convert Julian-style dates, "04070," to Gregorian, "03-11-04," and cannot get any of the following formulas to work (all found on this site & of course, I cannot find the original thread )

formulas:
dateserial(LEFT("2006015",4),1,RIGHT("2006015",3))
DateSerial(Int(2006130/1000), 1, 2006130 mod 1000)
dateadd("d",cint(right(x,3))-1, dateserial(cint(left(x,4)),1,1))

What am I doing wrong?

Frustration .....

Thanks

Reid