Shopping Cart

Search:

Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

# FileMaker Pro Custom Functions

Astrological_Sign(date)

Rate this function:

Discuss this Custom Function

John Pollard, Generic Human Studies
http://www.selfparenting.com

Determines a person's astrological sign based on their birthdate

Sample Input:
 Astro_sign( 12/6/1950 )
Sample Output:
 Sagittarius

Then copy & paste into FileMaker Advanced's Edit Custom Function window.

## Description:

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.

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

This is my Custom Function and I want to edit it

## Discuss:

Doesn't seem to work in FMPro 10 Adv.

Carl Riedel, Croydon, UK
December 24, 2009 2:21am

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")
)

Jay Dee, Antwerp
May 17, 2018 4:30am