I have the day of the year and need to calculate the date. What is the best way to do this?
I found this code to calculate the day of year - but nothing to reverse the day of year to a date.
lnDays = ldMyDate - gomonth(ldMyDate, - month(ldMyDate) + 1) + day(ldMyDate)
I'm sure I could set up a case statement for all the months and all the leap years. I was looking for a quickie!!
Thanks
Donna