Brian Dunning's FileMaker Custom Functions

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   John Pollard
Generic Human Studies
http://www.selfparenting.com

Share on Facebook Share on Twitter

  Sample input:
Astro_sign( 12/6/1950 )
  Sample output:
Sagittarius

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

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   Carl Riedel, Croydon, UK
Dec 24, 2009
Doesn't seem to work in FMPro 10 Adv.
 
Jay Dee   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.

Under construction. Email me your wish list for improvements.