Functions Reference

Chapter 3
|
Date functions 33
Data type returned
number
Description
Returns a number in the range 1 through 31, representing the day of the month on which
date occurs. For example, you can identify the day of the month that payments are due.
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
Day(“5/15/2004”) returns 15. This example assumes that the system date format is
MM/DD/YYYY.
Day(DateSold) returns the day of the month stored in DateSold.
If(Day(Get(CurrentDate))= 15 and
Month(Get(CurrentDate))=3;“Beware the Ides of March”;””) displays the
text Beware the Ides of March only when the day of the month returned by
Get(CurrentDate) is 15 and the month returned by Get(CurrentDate) is 3;
otherwise it displays nothing.
DayName
Format
DayName(date)
Parameter
date - any calendar date
Data type returned
text
Description
Returns a text string that is the full name of the weekday for 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
DayName(Date(10;7;2004)) returns Thursday.
DayName(ProjectDue) returns Friday when ProjectDue is 10/8/2004.
DayName(“10/10/2004”) returns Sunday.
“Return your selection by “& DayName(DueDate) displays the text Return
your selection by followed by the name of the day stored in DueDate.