Convert DayOfYear to Date

The following code converts a DayOfYear value to a Date.
DateSerial(Now.Year or the year you want, 1, DayOfYear Value).Date

No comments:

Post a Comment