Convert Day Number of year to date

[#1]

Hi Community,

How do I convert day number of the year to a month, day date?  It shouldn't give me year and I don't want it too.

Regards,

Brandon

[swuehl · Accepted solution]

The QV function daynumberofyear() always uses years based on 366 days (leap years). So we can use e.g. this year to calculate the month and day. If you have a field containing the DayNumberOfYear called DNOY, try

LOAD

DNOY,

day(makedate(2012)-1+DNOY) as Day,

month(makedate(2012)-1+DNOY) as Month

FROM ...;