Functions Reference

Chapter 3
|
Date functions 27
Day
Format
Day(date)
Parameter
date - any calendar date
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/2008”) 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.