Manualsbrain.com
  1. Manuals
  2. Brands
  3. Filemaker
  4. Pro 8.5 Educational Maintenance T3
  5. User Manual

Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Product codes
TJ083LL/A
Download
Page of 238
Chapter 3
  
|
  Date functions     31
Chapter 3
Date functions
Date
 calculate dates and manipulate date information.
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.
 affect the way dates are displayed. See FileMaker Pro help.
Click a function name for details.
This function
Returns
The calendar date for the specified month, day, and year. 
A number in the range 1 through 31, representing the day of the month for a 
specified date.
A text string that is the full name of the weekday for the specified date.
DayNameJ, page 34 A text string that is the full name of the weekday for the specified date in 
Japanese.
A number representing the day of the week the specified date falls on.
DayOfYear, page 35 A number equal to the number of days from the beginning of the year of the 
specified date.
A number in the range 1 through 12, representing the number of the month of the 
year in which the specified date occurs.
The name of the month for the specified date.
The name of the month in Japanese for the specified date.
The number of weeks after January 1 of the year of the specified date.
A number between 1 and 53 representing the week containing a specified date, 
figured according to the specified starting day. 
A number representing the year in which the specified date occurs.
YearName, page 39 The Japanese year name of the specified date, provided in the specified format.