Reference > Functions reference > Date functions > YearName
 

YearName

Returns the Japanese year name of a date, in the specified format.

Format 

YearName(date;format)

Parameters 

date - any calendar date

format - a number (0, 1, or 2) that describes the display format

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Description 

If the value for format is blank or other than 0, 1, or 2, then 0 is used.

0 - Japanese text for Emperor Meiji in long format8 (Meiji 8), Japanese text for Emperor Taisho in long format8 (Taisho 8), Japanese text for Emperor Showa in long format8 (Showa 8), Japanese text for Emperor Heisei in long format8 (Heisei 8), Japanese text for Emperor Seireki in long format (Seireki xxxx [before 1868.9.8])

1 - Japanese text for Emperor Meiji in abbreviated format8 (Mei 8), Japanese text for Emperor Taisho in abbreviated format8 (Tai 8), Japanese text for Emperor Showa in abbreviated format8 (Sho 8), Japanese text for Emperor Heisei in abbreviated format8 (Hei 8), Japanese text for Emperor Seireki in abbreviated formatxxxx (Sei xxxx [before 1868.9.8])

2 - M8, T8, S8, H8, A.D.xxxx (before 1868.9.8)

Name of Emperor in 0 = Long, 1 = Abbreviated, 2 = 2-byte roman. Seireki is returned when date is before listed emperors.

Example 1 

YearName ( DateField ; 0 ) returns Japanese text for the year name occurring on July 15, 2008 when DateField contains 7/15/2008.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Was this topic helpful? Send feedback.