Report: Faulty baptismal dates

From TNG_Wiki
Jump to navigation Jump to search

Report: Faulty baptismal dates . If you think From .. till is an acceptable date then you would have to add AND altbirthdate LIKE "From %"


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, lnprefix, lastname, firstname, altbirthdate, altbirthdatetr FROM tng_people 
WHERE Length( altbirthdate ) >4 
AND NOT 
( altbirthdate LIKE "Abt%" 
OR altbirthdate LIKE "Cal %" 
OR altbirthdate LIKE "Bef %" OR altbirthdate LIKE "Aft %" 
OR altbirthdate LIKE "Est %" OR altbirthdate LIKE "Bet %" 
OR altbirthdate LIKE "% BC" ) 
AND altbirthdatetr LIKE "%-00-00"