Brian Dunning's FileMaker Custom Functions

Zodiaco ( FECHA NAM ; sign )

Spanish version for astrological sing of a given date

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

carlos villamizar   carlos villamizar
carlos villamizar
https://plus.google.com/108876360486839869989

Share on Facebook Share on Twitter

  Sample input:
01/04/2015
  Sample output:
Aries

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

you can also change in your local database where "FECHA NAM" is replaced with birthday or any date

 

Comments

Agnès   Agnès, Paris
May 11, 2015
Hi,

Your Cf seems to be Zodiaco ( FECHA NAM ) ( not with ; sign )
may be this calc help to reduce for better understanding to debug ?

Let ([

D = GetAsDate ( FECHA NAM ) ;
A = Year ( D ) ;
DM = Date ( Month ( D ) ; Day ( D ) ; A )

];
Case (
DM > Date ( 12 ; 21 ; A ) ; "Capricornio";
DM > Date ( 11 ; 21 ; A ) ; "Sagittario";
DM > Date ( 10 ; 22 ; A ) ; "Scorpion";
DM > Date ( 9 ; 22 ; A ) ; "Libra";
DM > Date ( 8 ; 22 ; A ) ; "Virgo";
DM > Date ( 7 ; 22 ; A ) ; "Leo";
DM > Date ( 6 ; 20 ; A ) ; "Cancer";
DM > Date ( 5 ; 20 ; A ) ; "Geminis";
DM > Date ( 4 ; 19 ; A ) ; "Tauro";
DM > Date ( 3 ; 20 ; A ) ; "Aries";
DM > Date ( 2 ; 18 ; A ) ; "Piscis";
DM > Date ( 1 ; 19 ; A ) ; "Acuario";
DM < Date ( 1 ; 20 ; A ) ; "Capricornio";
"Necesito fecha de Nacimiento" )
)
 

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.