DayOfYear
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 version
6.0 or earlier
Example 1
DayOfYear ( Billing Date )
returns 32, when Billing Date is 2/1/2019.
Example 2
The following formulas return the total number of days in the current year:
Copy
DayOfYear (
Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) )
)
)
Copy
DayOfYear (
Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) ) + 1 ) - 1
)