^maikl11 Posted March 28, 2021 Report Share Posted March 28, 2021 Hello everybody I would like to create a report for all people whose birthday is "Today". I've already tried all possible variations, but nothing is displayed to me - or, I have an error in the SQL syntax! Here is the error message: Abfrage: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,birthdate,birthplace, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (LPAD(SUBSTRING_INDEX(=, ' ', 1),2,'0') SUBSTRING(NOW(), 1, 10)) AND tng_people.gedcom = "KLERC" ORDER BY lastname LIMIT 50You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=, ' ', 1),2,'0') SUBSTRING(NOW(), 1, 10)) AND tng_people.gedcom = "KLERC" ORDER' at line 1 Can someone help me with this? Thank you in advance!! Quote Link to comment Share on other sites More sharing options...
Rob Roy Posted March 28, 2021 Report Share Posted March 28, 2021 Try this: Birth Date (True) = CURDATE()+0 Quote Link to comment Share on other sites More sharing options...
^maikl11 Posted March 29, 2021 Author Report Share Posted March 29, 2021 vor 8 Stunden schrieb Rob Roy: Birth Date (True) = CURDATE()+0 Thanks for your help ... but it doesn't work ..... Quote Link to comment Share on other sites More sharing options...
Mark Posted March 29, 2021 Report Share Posted March 29, 2021 Try with following criteria : Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.