How to show a list of employees where anyone see todays birthday

Frappe HR
1

i have create a report to show todays birthday
using this report i want to show a list where this employee name can show
how to do?

3

Make the simple query report and check it.

SELECT
    employee_name as "Employee:Link/Employee:300", date_of_birth as "DOB:Date:300"
FROM
    `tabEmployee`
WHERE
    MONTH(date_of_birth) = MONTH(CURRENT_DATE)
    AND DAY(date_of_birth) = DAY(CURRENT_DATE)
4

@NCP i have a query report just that report i want to convert in to a list where only show that employee name

means suppose there is a list in that list show todays birthday employee name only

5

Remove this line and check it.

6

hi @NCP i have query report in that show day wise employee
i have create one workspace in that i want to show one list in which show todays birthday of employee name like this

image
image800×383 52.5 KB

7

Not possible in the quick list, but you can do it with Custom HTML Block with some code logic.