How to Display Upcoming Birthdays in the Next 14 Days?

[yinfanyi]

Hello everyone! I'm currently using the Dataview plugin in Obsidian and I've encountered an issue. I want to create a table that lists the friends who have birthdays in the next 14 days, but I'm not quite sure how to modify my existing code.

Here’s the code I have so far, I don't know why it won't work:

dataview
table without id file.link as Birthday, birthday as "Coming Soon"   
from #people/friend   

where follow_up = true   
and date(replace(birthday, birthday.year, today.year)) >= date(today)   
and date(replace(birthday, birthday.year, today.year)) <= date(today) + dur(14 days)  

for example, today is 2024/10/5, I want to display this gay's name and its birthday