Zodiac_tw ( birthDate )

Enter the date and display the Chinese zodiac name.

Be the first to rate this function Log in to vote

Bing Liu - Show more from this author
MINGYI
https://EasyApps.biz

Sample input:

Zodiac_tw ( 2017/3/8 )

Sample output:

雙魚座

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Case( ( Month(birthDate) = 3 and Day(birthDate) >= 21) or (Month(birthDate) = 4 and Day(birthDate) <= 19), "白羊座",
(Month(birthDate) = 4 and Day(birthDate) >= 20) or (Month(birthDate) = 5 and Day(birthDate) <= 20), "金牛座",
(Month(birthDate) = 5 and Day(birthDate) >= 21) or (Month(birthDate) = 6 and Day(birthDate) <= 20), "雙子座",
(Month(birthDate) = 6 and Day(birthDate) >= 21) or (Month(birthDate) = 7 and Day(birthDate) <= 22), "巨蟹座",
(Month(birthDate) = 7 and Day(birthDate) >= 23) or (Month(birthDate) = 8 and Day(birthDate) <= 22), "獅子座",
(Month(birthDate) = 8 and Day(birthDate) >= 23) or (Month(birthDate) = 9 and Day(birthDate) <= 22), "處女座",
(Month(birthDate) = 9 and Day(birthDate) >= 23) or (Month(birthDate) = 10 and Day(birthDate) <= 22), "天秤座",
(Month(birthDate) = 10 and Day(birthDate) >= 23) or (Month(birthDate) = 11 and Day(birthDate) <= 21), "天蠍座",
(Month(birthDate) = 11 and Day(birthDate) >= 22) or (Month(birthDate) = 12 and Day(birthDate) <= 21), "射手座",
(Month(birthDate) = 12 and Day(birthDate) >= 22) or (Month(birthDate) = 1 and Day(birthDate) <= 19), "摩羯座",
(Month(birthDate) = 1 and Day(birthDate) >= 20) or (Month(birthDate) = 2 and Day(birthDate) <= 18), "水瓶座",
(Month(birthDate) = 2 and Day(birthDate) >= 19) or (Month(birthDate) = 3 and Day(birthDate) <= 20), "雙魚座",
"請輸入生日")

The function name is Zodiac_tw, as long as the date is entered, such as: 2017/3/8, the Chinese zodiac name will be displayed automatically，

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Zodiac_tw ( birthDate )

Comments

Support this website.

Support this website.