Date Value from Year and Day of Year Columns?

[RandyS]

Greetings,

I have a daily weather data table that includes only a Year column and a Day of Year column for date references. Is it possible to convert those two values to a date? I couldn’t find an M code function that worked.

Thank you!
Randy

[Matthias]

Hi Randy,
yes you can e.g. with Date.AddDays(#date([Year],1,1), [Day of Year]-1)

Regards,
Matthias

[RandyS]

Thank you, Matthias. Perfect. I didn’t know enough to use Date.AddDays and #date in conjunction.