Skip to main content
Best answer by Ninetrees

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~

3 replies

Ninetrees3-NewcomerAnswer
3-Newcomer
October 13, 2010

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~

1-Visitor
October 14, 2010

got it. thanks.

19-Tanzanite
October 15, 2010

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

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

1-Visitor
October 15, 2010

Is this file required for the problem in question?

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

Mike