Help to database query and field data

[kamil]

Welcome
I need help with php and database query. I have a database and field data. Needs to pull out of the base date on the same day and month in fablikar pre-filter.

I could ask you a few examples of questions like "today's date - 1 day" or "+ 1 day".
Plans to create a timeline of historical events for the day and I have a problem with removing the date from the database (eg 1609.12.11). This event should appear to 11.12 every year.

How to set the plugin "birthday" in fabrikar to show birthday yesterday or tomorrow.
Setting "Today" work fine.

 

[Jaanus]

Use CURDATE() instead NOW() as the db field type is DATE, not DATETIME.
See also mysql tutorial, perhaps you should use something like DATE_ADD(CURDATE(), "-1 DAY")