Filemaker TH325Z/A Datasheet download pdf (Page 39)

Chapter 3

Date functions 39

Examples

Year(DateSold) returns the year stored in DateSold.

Year(“5/5/2004”) returns 2004.

Year(Date(Month(Get(CurrentDate)) +

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

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.

Example

YearName(DateField;0) Returns when DateField contains 7/17/2002.

1 2 ... 34 35 36 37 38 39 40 41 42 43 44 ... 237 238

No comments

Filemaker TH325Z/A Datasheet Page 39