daynum
function returns the day of the year (1 through 355 or 356) for date.
Syntax
daynum(date(year, month, day))
Parameters
date
can be any of the following:- Another function that returns a date.
- A formula column that returns a date.
year
: 4 digits.
For example, 2012month
: 2 digits.
For example, 01 or 12day
: 2 digits.
For example, 01 or 30
Examples
daynum(date(2020,12, 25))
= 360