AnsweredAssumed Answered

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

Question asked by joostje on Nov 12, 2015
Latest reply on Nov 12, 2015 by TomHays

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

Outcomes