Help

Re: Formula for day of the year

Solved
Jump to Solution
1623 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SteelsmithHaus
6 - Interface Innovator
6 - Interface Innovator

I’m probably missing something, but how do I get the current day of the year? For instance, we have WEEKNUM(TODAY()), but not DAYNUM(TODAY())?

I can do year(today()), and week(today() but when I do day(today()) it shows the day of the month and not the year. Thanks!

Example: Jan 1st 2021 is day 1, etc.

1 Solution

Accepted Solutions
Dominik_Bosnjak
10 - Mercury
10 - Mercury

Easiest way that comes to mind:

DATETIME_FORMAT(NOW(),"DDD")

Edit: Bookmark this page and ride off into a meticulously formatted sunset. :horse_racing:

See Solution in Thread

3 Replies 3
Dominik_Bosnjak
10 - Mercury
10 - Mercury

Easiest way that comes to mind:

DATETIME_FORMAT(NOW(),"DDD")

Edit: Bookmark this page and ride off into a meticulously formatted sunset. :horse_racing:

Bob_Rutledge
5 - Automation Enthusiast
5 - Automation Enthusiast

I wanted record grouped by the dScreenshot 2023-02-03 3.05.51 PM.pngate the record was created. 

Hi @Dominik_Bosnjak -- thanks for this.

Curious though why I can't take the product of this formula and use it in a percentage formula. 

For example, if I take your fomule and divide by 365, I get an error:

DATETIME_FORMAT(NOW(),"DDD")/365
 
 
What am I doing wrong? 

Please and thank you 🙏