Find faulty eventdates

From TNG_Wiki
Jump to navigation Jump to search

Technically you could make this into a report as well, but in this case it's handier to use it in MySQL since you can't find the proper people connected to the events. In MySQL it's easy to change these dates. Don't forget to change the true date as well when editing.

Copy and paste the text between the lines into the MySQL section of your MySQL admin, IMPORTANT: Make a backup before you try anything and use this at your own risk!


SELECT persfamID, eventdate, eventdatetr 
FROM tng_events
WHERE Length( eventdate ) >4
AND NOT (
eventdate LIKE "Abt%"
OR eventdate LIKE "Cal %"
OR eventdate LIKE "Bef %"
OR eventdate LIKE "Aft %"
OR eventdate LIKE "Est %"
OR eventdate LIKE "Bet %"
OR eventdate LIKE "% BC"
)
AND eventdatetr LIKE "%-00-00"