DAY_OF_YEAR

Calculates the day of the year for a given date or datetime

Updated over a week ago

Description

The DAY_OF_YEAR() function computes and returns the day of the year for a given date or datetime, indicating which day of the year it is. This can be valuable for time-based analytics, scheduling, or date-based calculations.

Syntax

DAY_OF_YEAR(date)

Output

integer

Variables

  1. date: The date or datetime for which you want to determine the day of the year.

Example

DAY_OF_YEAR(`Event Date`)

Event

Event Date

DAY_OF_YEAR

Event A

September 10, 2023

253

Event B

August 25, 2023

237

Event C

January 15, 2023

15

Did this answer your question?