Report: Aries
Zur Navigation springen
Zur Suche springen
Description: People, born in the astrological sign Aries: 21 March -20 April
Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate
SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living
FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>"" AND ((MONTH(birthdatetr)=3
AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)<=20))
ORDER BY lastname, firstname, personID