Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula for day of the year

Topic Labels: Formulas
354 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

2 Replies 2

Easiest way that comes to mind:

DATETIME_FORMAT(NOW(),"DDD")

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

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