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

32 FileMaker Functions Reference

Date

Format

Date(month;day;year)

Parameters

month - the month of the year (a number from 1 to 12).

day - the day of the month (a number from 1 to 31).

year - the year (four digits between 0001 and 4000. For example, 2005 but not 05).

Important The order of the parameters in the Date function is always Month, Day, Year, no

matter what operating system or FileMaker Pro date formats you are using.

Data type returned

date

Description

Returns the calendar date for month, day, and year.

The format of the result depends on the date format that was in use when the database

file was created. In the United States, dates are generally in the format MM/DD/YYYY.

You can change the date format in the Regional Settings Control Panel (Windows 2000),

the Date and Time Control Panel (Windows XP), or the Date & Time System Preference

(Mac OS).

You can change how the date is displayed by assigning a different date format to the field

in Layout mode. Changing the formatting in this way only affects the way the data is

displayed, not how it is stored.

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.

Note If you type a month greater than 12 or a day greater than the number of days in a

month, FileMaker Pro adds the extra days or months to the result. For example,

Date(13;1;2004) returns 1/1/2005.

Example

Date(10;11;2004) returns 10/11/2004.

Day

Format

Day(date)

Parameter

date - any calendar date

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

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 32