daynum

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, 2012
• month: 2 digits.
  For example, 01 or 12
• day: 2 digits.
  For example, 01 or 30

Examples

daynum(date(2020,12, 25)) = 360

Related links

• Use functions in custom columns
• day
• month
• year
• weekday
• weeknum
• offset_days