Filemaker TH325Z/A Fiche technique télécharger pdf (Page 33)

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.

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 33