Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Date functions > YearName function |
|
|
| YearName function |
| 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 |
| 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 - 
8 (Meiji 8), 
8 (Taisho 8), 
8 (Showa 8), 
8 (Heisei 8), 
(Seireki xxxx [before 1868.9.8]) |
1 - 
8 (Mei 8), 
8 (Tai 8), 
8 (Sho 8), 
8 (Hei 8), 
xxxx (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 |
YearName(DateField;0) Returns
when DateField contains 7/17/2008. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Date functions > YearName function |
|
|
Next Page |
|