Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
Chapter 3
|
Date functions 39
Examples
Year(DateSold) returns the year stored in DateSold.
Year(“5/5/2004”) returns
Year(“5/5/2004”) returns
2004
.
Year(Date(Month(Get(CurrentDate)) +
48;Day(Get(CurrentDate));Year(Get(CurrentDate)))) returns the year that
48;Day(Get(CurrentDate));Year(Get(CurrentDate)))) returns the year that
is 48 months from today’s date.
YearName
Format
YearName(date;format)
Parameters
date - any calendar date
format - a number (0, 1, or 2) that describes the display format
format - a number (0, 1, or 2) that describes the display format
Data type returned
text
Description
Returns the Japanese year name of date, provided in the specified format. If the value
for format is blank or other than 0, 1, or 2, then 0 is used.
Format
0 - Meiji (
) 8, Taisho (
) 8, Showa (
) 8, Heisei (
) 8 (before 1868.9.8,
Seireki (
)
1 - Mei (
) 8, Tai (
) 8, Sho (
) 8, Hei (
) 8 (before 1868.9.8, Sei (
)
2 - M8, T8, S8, H8 (before 1868.9.8, A.D.xxxx)
Name of Emperor in 0 = Long, 1 = Abbreviated, 2 = 2 byte Roman. Seireki is returned
when date is before listed emperors.
Name of Emperor in 0 = Long, 1 = Abbreviated, 2 = 2 byte Roman. Seireki is returned
when date is before listed emperors.
Example
YearName(DateField;0) Returns
when DateField contains 7/17/2002.