How to create monthly 'day of the year' numbers

[MySchizoBuddy]

DaysInMonth := (31 29 31 etc)

Jan := 1..31

Feb := 32..59

Mar := 60..90

Source file for M14 is attached

[Ninetrees · Accepted 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~

[MySchizoBuddy]

got it. thanks.

[RichardJ]

I just updated the Dates document with function to do this.

http://communities.ptc.com/docs/DOC-1395

[MikeArmstrong]

Is this file required for the problem in question?

Even though I must add there's some good work within the worksheet now.

Mike