Home > Reference > Functions reference > Date functions > DayOfYear
DayOfYear Purpose Returns a number equal to the number of days from the beginning of the year of 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