turn on suggestions

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

Showing results for

- JMP User Community
- :
- 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
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2016 8:46 AM
(2608 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
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2016 8:46 AM
(2609 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
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2016 9:01 AM
(1304 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.