Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 3

  

|

  Date functions     33

number

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.

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.

Day(“5/15/2004”) returns 

. 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 

 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(date)

date - any calendar date

text

Returns a text string that is the full name of the weekday for date.

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.

DayName(Date(10;7;2004)) returns 

.

DayName(ProjectDue) returns 

 when ProjectDue is 10/8/2004.

DayName(“10/10/2004”) returns 

.

“Return your selection by “& DayName(DueDate) displays the text 

 

 followed by the name of the day stored in DueDate.