1 Reply Latest reply on Nov 12, 2015 7:28 AM by TomHays

    how to calculate astrologigal sign from birthdate and show a symbol + number 1-9

    joostje

      I have a database with students and I want to group them according to astrological sign and routenumber (= all nummbers of the birthdat added together: 20-05-1996 adds up to 5). It would be nice to see a symbol and a number

      This is the data I use for the astrological signs:

       

      Naam

      Symbool

      Van

      tot

      Aries

       

      21-03

      19-04

      Taurus

       

      20-04

      21-05

      Gemini

       

      21-05

      21-06

      Cancer

       

      21-06

      23-07

      Leo

       

      23-07

      23-08

      Virgo

       

      23-08

      23-09

      Libra

       

      23-09

      23-10

      Scorpio

       

      23-10

      22-11

      Sagittarius

       

      22-11

      22-12

      Capricornus

       

      22-12

      20-01

      Aquarius

       

      20-01

      19-02

      Pisces

       

      19-02

      21-03

       

      I have no idea how to get this done

       

      Thanks

        • 1. Re: how to calculate astrologigal sign from birthdate and show a symbol + number 1-9
          TomHays

          You need two calculations: one to figure out the astrological sign from the birthdate and one to add the day, month, and year.

          How you implement these calculations is up to you.  It sounds like you would want to make a calculated field.

           

          A calculation like this will give you the sign.

           

          Let(

          [

          bd = birthdate;

          by = Year(birthdate)

          ];

          Case(

          bd  ≥ Date(3;21;by) and bd  ≤ Date(4;19;by); "Aries";

          bd  ≥ Date(4;20;by) and bd  ≤ Date(5;21;by); "Taurus";

          /* Add lines like those above to cover all date ranges except Capricornus */

          "Capricornus"

          )

          )

           

          A calculation like this will give you the "routenumber".

           

          Day(birthdate) + Month(birthdate) + Year(birthdate)

           

           

          -Tom