Functions Reference

Chapter 3
|
Date functions 29
Description
Returns a number representing the day of the week that date falls on. The number 1
represents Sunday, 2 represents Monday, 3 represents Tuesday, and so on. For
example, you can find out on what day of the week a holiday 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.
Examples
DayOfWeek(“10/8/2008”) returns 4.
DayOfWeek(Date(10;9;2008)) returns 5.
DayOfWeek(ProjectDue) returns 3 when the date in ProjectDue is 10/7/2008.
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 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)