Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Date functions > DayOfYear function |
|
|
| DayOfYear function |
| Format |
DayOfYear(date) |
| Parameter |
| date - any calendar date |
| Data type returned |
| number |
| Description |
| Returns a number equal to the number of days from the beginning of the year of date. |
| 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. |
| Examples |
| DayOfYear(Billing Date) returns 32, when Billing Date is 2/1/2008. |
| 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) |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Date functions > DayOfYear function |
|
|
Next Page |
|