Jump to content
TNG Community
^maikl11

Report error for Birthday "today"!!

Recommended Posts

^maikl11

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 50

You 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!!

birthday today.png

Share this post


Link to post
Share on other sites
Rob Roy

Try this:

Birth Date (True)

=

CURDATE()+0

Share this post


Link to post
Share on other sites
^maikl11
vor 8 Stunden schrieb Rob Roy:

Birth Date (True)

=

CURDATE()+0

Thanks for your help ... but it doesn't work .....

Share this post


Link to post
Share on other sites
Mark

Try with following criteria :

image.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×