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