Reference > Functions reference > Date functions > DayOfYear
 

DayOfYear

Returns the number of days from the beginning of the year of a date.

Format 

DayOfYear ( date )

Parameters 

date - any calendar date

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

DayOfYear ( Billing Date ) returns 32, when Billing Date is 2/1/2019.

Example 2 

The following formulas return the total number of days in the current year:

DayOfYear (
   Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) )
   )
)
DayOfYear (
   Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) ) + 1 ) - 1
)

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas