Report: Faulty baptismal dates
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"