How do I convert dayofyear into a calendar date to use with the makedate calculation?
So what inputs do you have? Just one number or number and a year?
Regardless, you make a date for January 1st (with your year or fixed to some year) and then you add days to it with DATEADD.
Retrieving data ...