Turn yeardaynumber into date

[#1]

How can I turn a yeardaynumber into a date eg

12001 --> 01-01-2012 or

12282 --> 08-10-2012

Thanks!

[Gysbert_Wassenaar · Accepted solution]

makedate(left(YearDayNumber,2)+2000,1,1) + Right(YearDayNumber,3) -1  as MyDate