Returns the number of days from the beginning of the year of a date.
DayOfYear ( date )date - any calendar date
number
FileMaker Pro 6.0 or earlier
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
)