Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
DaysInMonth := (31 29 31 etc)
Jan := 1..31
Feb := 32..59
Mar := 60..90
Source file for M14 is attached
Solved! Go to Solution.
It depends on what you intend to do with the data...(and you might want to post excerpts of large files that illustrate your point or need...)
You could create an array DaysInMonth 0..12 of ( 0, 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31)
and this one
JulianDays array [0..12] of (0, 31, 59, 90,120,151,181,212,243,273,304,334,365)
Then it's up to you to use them...for example (do you intend to do real date stuff with them? leap years, etc?) Feb 2 is DaysInMonth[1 + 2 to get the Julian day of the year. I wouldn't be surprised to find that someone has already addressed this in the forum...
~R~
It depends on what you intend to do with the data...(and you might want to post excerpts of large files that illustrate your point or need...)
You could create an array DaysInMonth 0..12 of ( 0, 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31)
and this one
JulianDays array [0..12] of (0, 31, 59, 90,120,151,181,212,243,273,304,334,365)
Then it's up to you to use them...for example (do you intend to do real date stuff with them? leap years, etc?) Feb 2 is DaysInMonth[1 + 2 to get the Julian day of the year. I wouldn't be surprised to find that someone has already addressed this in the forum...
~R~
got it. thanks.
I just updated the Dates document with function to do this.
Is this file required for the problem in question?
Even though I must add there's some good work within the worksheet now.
Mike