How to find birthdays in the current month?

this not work

How to return only the birthdays of the month? @Teodor?

1 Like

Hi Adriano,
Please explain what exactly are you trying to achieve.

I don’t know how to make a query that brings me all users with date of birth in month 06 for example

I don’t know if it’s the same subject as the post it seems to me the same thing

So basically you need to filter your database query to show all the records between the 1st and the last day of the current month?

No, I just want the records with the birthday in the current month

how to bring only users born in month 06?

You need a custom query for that. If you are using MySQL then it will look like:

SELECT nome, data_nascimento 
FROM dates 
WHERE MONTH(data_nascimento) = MONTH(NOW())
1 Like

thanks Teodor

Any chance of this coming in the query builder? @patrick

Which part of the query are you referring to Adriano?

In Query Builder so you don’t have to use a custom query :stuck_out_tongue_winking_eye:

No, the only way to do this is using a custom query. And there is nothing wrong with that, as the component is used in exactly such cases.

ok thanks Teodor