Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I turn a yeardaynumber into a date eg
12001 --> 01-01-2012 or
12282 --> 08-10-2012
Thanks!
makedate(left(YearDayNumber,2)+2000,1,1) + Right(YearDayNumber,3) -1 as MyDate
makedate(left(YearDayNumber,2)+2000,1,1) + Right(YearDayNumber,3) -1 as MyDate