Reference > Functions reference > Date functions > DayOfYear
 
DayOfYear
Purpose 
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
Examples 
DayOfYear ( Billing Date ) returns 32, when Billing Date is 2/1/2019.
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 )
Important  To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Entering dates with two-digit years.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas