Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
Chapter 3
|
Date functions 35
DayOfYear
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 FileMaker Pro help.
Examples
DayOfYear(Billing Date) returns
33
, when Billing Date is 2/2/2005.
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)
DayOfYear(Date(1;1;Year(Get(CurrentDate)) + 1) -1)
Month
Format
Month(date)
Parameter
date - any calendar date
Data type returned
number
Description
Returns a number in the range 1 through 12, representing the number of the month of the
year in which date occurs.
year in which date occurs.
Important
To avoid errors when using dates, always use four-digit years. For more
information about how FileMaker Pro handles two-digit dates, see FileMaker Pro help.