Skip to main content
Converts a date to the number day of the year, from 1 (Jan 1) to 365 (Dec 31). Accounts for leap years. Category: date Syntax: 
DayOfYear([date], |timezone|)
Returns: IntColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
datecolumn|datetime✓ YesThe date or column of date values to evaluate.
timezonetext✗ NoOptional IANA time zone name (e.g., “Europe/Amsterdam”).
Allowed Column Types: DATETIME, DATE

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

​
Examples

DayOfYear(Date("2023-01-01"))
Converts Jan 1, 2023 to the number day of the year. Result: 1 
DayOfYear(Date("2023-12-31"))
Converts Dec 31, 2023 to the number day of the year. Result: 365 
DayOfYear(Date("2024-12-31"))
Converts Dec 31, 2024 (leap year) to the number day of the year. Result: 366 
DayOfYear(Date("2023-01-03 02:00:00Z"), "Europe/Amsterdam")
Converts Jan 3, 2023 02:00:00Z to the number day of the year in New York. Result: 2
Last modified on March 13, 2026