
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2021 11:56 AM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2021 12:16 PM
Easiest way that comes to mind:
DATETIME_FORMAT(NOW(),"DDD")
Edit: Bookmark this page and ride off into a meticulously formatted sunset. :horse_racing:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2021 12:16 PM
Easiest way that comes to mind:
DATETIME_FORMAT(NOW(),"DDD")
Edit: Bookmark this page and ride off into a meticulously formatted sunset. :horse_racing:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 03, 2023 01:08 PM
I wanted record grouped by the date the record was created.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2023 08:11 AM
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:
Please and thank you 🙏
