Adding and viewing data > Entering data in records > Entering Japanese Emperor Year dates
 

Entering Japanese Emperor Year dates

You can enter Japanese Emperor Year (Wareki) dates in date fields. FileMaker Pro Advanced changes the Emperor Year to a Western Gregorian (Seireki) year and saves it internally in the format specified by the file. The display format of the date—Western or Japanese—depends on the date field format.

To enter Japanese Emperor Year dates, precede the date with the era abbreviation (shown below). Use the format letterY/M/D, where letter designates the era, followed by the year, month, and day.

For example, M1/12/30 is changed to 1868/12/30 (M1 = the 1st year of Meiji, or 1868). Similarly, T1/12/30 becomes 1912/12/30, S1/12/30 becomes 1926/12/30, and H1/12/30 becomes 1989/12/30

 

Era letter

Era name

Era formats

Reign

 

Japanese kanji pronounced seireki A.D. (anno Domini)

Japanese kanji pronounced seireki, Japanese kanji pronounced sei, A.D.

prior to 1868/09/08

m, M

Japanese kanji pronounced meiji Meiji

Japanese kanji pronounced meiji, Japanese kanji pronounced mei, M

1868/09/08 - 1912/07/29 (M1 - M45)

t, T

Japanese kanji pronounced taisho Taisho

Japanese kanji pronounced taisho, Japanese kanji pronounced tai, T

1912/07/30 - 1926/12/24 (T1 - T15)

s, S

Japanese kanji pronounced showa Showa

Japanese kanji pronounced showa, Japanese kanji pronounced sho, S

1926/12/25 - 1989/01/07 (S1 - S64)

h, H

Japanese kanji pronounced heisei Heisei

Japanese kanji pronounced heisei, Japanese kanji pronounced hei, H

1989/01/08 -  (H1 -  )

Notes 

You can enter era letters in lowercase or uppercase, and as full-width or half-width characters. Full-width numbers (but not the date separators) are changed to half width when you exit the field in Browse or Find modes.

You can use any supported date separator.

An era abbreviation letter followed by 0 (zero) is interpreted as the year prior to the first year of that era. For example, M0 = 1867, T0 = 1911, and so on.

If you enter a 1- or 2-digit year without the preceding era letter, FileMaker Pro Advanced produces a 4-digit year based on the Gregorian calendar when you use the plus sign (+) as the date separator. For example, a date entered as 30+1+20 is interpreted as 2030/1/20, instead of 2018/1/20. To produce the date 2018/1/20, enter h30+1+20 (or H30+1+20).