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/2014.
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 Conversion of 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
Was this topic helpful? Send feedback.