Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Is there an inverse to the Day Of Year() function?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2016 8:31 AM
(2343 views)

I have a day of year column, and need to convert it to a date. I've wracked my brain over this. There's probably a simple solution but it escapes me.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2016 8:46 AM
(4574 views)

Solution

I assume you have a year column as well.

If so, you just need to multiply your Day of Year column by the number of seconds in a day (the In Days(1) function will give you this) and add it to the value for December 31 of the previous year. It sounds worse in prose than it really is.

:Day of Year * In Days(1) + Date DMY(31, 12, :Year - 1)

-Jeff

-Jeff

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2016 8:46 AM
(4575 views)

I assume you have a year column as well.

If so, you just need to multiply your Day of Year column by the number of seconds in a day (the In Days(1) function will give you this) and add it to the value for December 31 of the previous year. It sounds worse in prose than it really is.

:Day of Year * In Days(1) + Date DMY(31, 12, :Year - 1)

-Jeff

-Jeff

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2016 9:01 AM
(2287 views)

Perfect! The data is all this year so far, so I don't need the year column yet.

Thanks! Yes that was simpler than I thought. I was getting frustrated, and I nearly did in in {shudder} Excel, but then I would have had to copy it back and forth every few days.