Latest Enterprise DNA Initiatives

Date Value from Year and Day of Year Columns?


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!

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


1 Like

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

1 Like