Filemaker Pro 8.5 Educational Maintenance T1 TJ086LL/A 用户手册
产品代码
TJ086LL/A
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.
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
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.