Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

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 https://plus.google.com/108876360486839869989

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

Case( (Month(FECHA NAM) = 3 and Day(FECHA NAM) >= 21) or (Month(FECHA NAM) = 4 and Day(FECHA NAM) <= 19); "Aries"; (Month(FECHA NAM) = 4 and Day(FECHA NAM) >= 20) or (Month(FECHA NAM) = 5 and Day(FECHA NAM) <= 20); "Tauro"; (Month(FECHA NAM) = 5 and Day(FECHA NAM) >= 21) or (Month(FECHA NAM) = 6 and Day(FECHA NAM) <= 20); "Geminis"; (Month(FECHA NAM) = 6 and Day(FECHA NAM) >= 21) or (Month(FECHA NAM) = 7 and Day(FECHA NAM) <= 22); "Cancer"; (Month(FECHA NAM) = 7 and Day(FECHA NAM) >= 23) or (Month(FECHA NAM) = 8 and Day(FECHA NAM) <= 22); "Leo"; (Month(FECHA NAM) = 8 and Day(FECHA NAM) >= 23) or (Month(FECHA NAM) = 9 and Day(FECHA NAM) <= 22); "Virgo"; (Month(FECHA NAM) = 9 and Day(FECHA NAM) >= 23) or (Month(FECHA NAM) = 10 and Day(FECHA NAM) <= 22); "Libra"; (Month(FECHA NAM) = 10 and Day(FECHA NAM) >= 23) or (Month(FECHA NAM) = 11 and Day(FECHA NAM) <= 21); "Scorpion"; (Month(FECHA NAM) = 11 and Day(FECHA NAM) >= 22) or (Month(FECHA NAM) = 12 and Day(FECHA NAM) <= 21); "Sagittario"; (Month(FECHA NAM) = 12 and Day(FECHA NAM) >= 22) or (Month(FECHA NAM) = 1 and Day(FECHA NAM) <= 19); "Capricornio"; (Month(FECHA NAM) = 1 and Day(FECHA NAM) >= 20) or (Month(FECHA NAM) = 2 and Day(FECHA NAM) <= 18); "Acuario"; (Month(FECHA NAM) = 2 and Day(FECHA NAM) >= 19) or (Month(FECHA NAM) = 3 and Day(FECHA NAM) <= 20); "Piscis"; "Necesito fecha de Nacimiento") Click to copy

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

 

Comments

		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.

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: