topic Date Week of the year in Discussions

Date Week of the year

lisamaley — Thu, 08 Jun 2023 16:41:24 GMT

I have a date code that gives me the year, day of the week (Saturday for instance) and the week of the year (week 50 for instance). Is there a way to change this information into a date?

I have a MacBook Monterey 12.6 with JMP Pro version 17.0

Re: Date Week of the year

txnelson — Wed, 25 Jan 2023 05:25:05 GMT

This equation will calculate the date given the 3 variables you specified

In Years( :year - 1904 ) + In Weeks( :week of the year ) + In Days( :day of the week )

This equation assumes the week of the year begins on January 1. If your data has a rule for what day the week of the year begins, like the first Sunday of the year that offset will have to be calculated and then added to the formula.

Re: Date Week of the year

Craige_Hales — Wed, 25 Jan 2023 11:30:33 GMT

Also, make allowances for day-of-week and week-of-year starts with 0 or 1.

Jim is right, there are a lot of ways you might define week of the year. Many of the worst bugs I've worked on had something to do with time calculations. Test your code carefully!

Re: Date Week of the year

lisamaley — Wed, 25 Jan 2023 13:55:30 GMT

Thank you! this worked!

Re: Date Week of the year

lisamaley — Wed, 25 Jan 2023 13:56:31 GMT

I changed it to a number first and it worked!