Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

Astrological_Sign ( date )

Determines a person's astrological sign based on their birthdate

  Average rating: 4.5 (28 votes) Log in to vote

John Pollard - Show more from this author Generic Human Studies http://www.selfparenting.com

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

Case( (Month(a6_person_birth_date) = 3 and Day(a6_person_birth_date) >= 21) or (Month(a6_person_birth_date) = 4 and Day(a6_person_birth_date) <= 19), "Aries", (Month(a6_person_birth_date) = 4 and Day(a6_person_birth_date) >= 20) or (Month(a6_person_birth_date) = 5 and Day(a6_person_birth_date) <= 20), "Taurus", (Month(a6_person_birth_date) = 5 and Day(a6_person_birth_date) >= 21) or (Month(a6_person_birth_date) = 6 and Day(a6_person_birth_date) <= 20), "Gemini", (Month(a6_person_birth_date) = 6 and Day(a6_person_birth_date) >= 21) or (Month(a6_person_birth_date) = 7 and Day(a6_person_birth_date) <= 22), "Cancer", (Month(a6_person_birth_date) = 7 and Day(a6_person_birth_date) >= 23) or (Month(a6_person_birth_date) = 8 and Day(a6_person_birth_date) <= 22), "Leo", (Month(a6_person_birth_date) = 8 and Day(a6_person_birth_date) >= 23) or (Month(a6_person_birth_date) = 9 and Day(a6_person_birth_date) <= 22), "Virgo", (Month(a6_person_birth_date) = 9 and Day(a6_person_birth_date) >= 23) or (Month(a6_person_birth_date) = 10 and Day(a6_person_birth_date) <= 22), "Libra", (Month(a6_person_birth_date) = 10 and Day(a6_person_birth_date) >= 23) or (Month(a6_person_birth_date) = 11 and Day(a6_person_birth_date) <= 21), "Scorpio", (Month(a6_person_birth_date) = 11 and Day(a6_person_birth_date) >= 22) or (Month(a6_person_birth_date) = 12 and Day(a6_person_birth_date) <= 21), "Sagittarius", (Month(a6_person_birth_date) = 12 and Day(a6_person_birth_date) >= 22) or (Month(a6_person_birth_date) = 1 and Day(a6_person_birth_date) <= 19), "Capricorn", (Month(a6_person_birth_date) = 1 and Day(a6_person_birth_date) >= 20) or (Month(a6_person_birth_date) = 2 and Day(a6_person_birth_date) <= 18), "Aquarius", (Month(a6_person_birth_date) = 2 and Day(a6_person_birth_date) >= 19) or (Month(a6_person_birth_date) = 3 and Day(a6_person_birth_date) <= 20), "Pisces", "Need Birthday") Click to copy

Increase your techno-sexual quotient with this handy function for your PEOPLE database. I use this as a calculation field in FM 6. Not sure if this is official 7 linguistics or not but it works and people like it when you know their sign without any effort.

 

Comments

		Carl Riedel, Curator Contender Dec 24, 2009
Doesn't seem to work in FMPro 10 Adv.

		Jay Dee, Antwerp May 17, 2018
It probably does work but needs some changes. The parameter is different here (also, "date" is not accepted in FM, so use "birthdate"), and depending on your version/locale "," may need to become ";". This version works for me: Let ( BD = birthdate ; Case( (Month(BD) = 3 and Day(BD) >= 21) or (Month(BD) = 4 and Day(BD) <= 19); "Aries"; (Month(BD) = 4 and Day(BD) >= 20) or (Month(BD) = 5 and Day(BD) <= 20); "Taurus"; (Month(BD) = 5 and Day(BD) >= 21) or (Month(BD) = 6 and Day(BD) <= 20); "Gemini"; (Month(BD) = 6 and Day(BD) >= 21) or (Month(BD) = 7 and Day(BD) <= 22); "Cancer"; (Month(BD) = 7 and Day(BD) >= 23) or (Month(BD) = 8 and Day(BD) <= 22); "Leo"; (Month(BD) = 8 and Day(BD) >= 23) or (Month(BD) = 9 and Day(BD) <= 22); "Virgo"; (Month(BD) = 9 and Day(BD) >= 23) or (Month(BD) = 10 and Day(BD) <= 22); "Libra"; (Month(BD) = 10 and Day(BD) >= 23) or (Month(BD) = 11 and Day(BD) <= 21); "Scorpio"; (Month(BD) = 11 and Day(BD) >= 22) or (Month(BD) = 12 and Day(BD) <= 21); "Sagittarius"; (Month(BD) = 12 and Day(BD) >= 22) or (Month(BD) = 1 and Day(BD) <= 19); "Capricorn"; (Month(BD) = 1 and Day(BD) >= 20) or (Month(BD) = 2 and Day(BD) <= 18); "Aquarius"; (Month(BD) = 2 and Day(BD) >= 19) or (Month(BD) = 3 and Day(BD) <= 20); "Pisces"; "Need Birthday") )

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: