Returns the numbered day of the year for the specified date value.
Syntax
DAYYEAR(dateval)
Example
If mydatefield has value '2024-10-30 09:55:00', then:
DAYYEAR({{mydatefield}})
returns: 304
Notes
Values returned are between 1 and 366.
Related
DAYWEEK
WEEKYEAR
