Compare access db birthday date field with date

[CZ]

Hello,

I have a list of employees with their birhtdays. I would like to to
have a datagrid list employees with birthdays on the current month on a
web page.

I tried

select * from tbldate where month(bdate) = month(date())

but it does not work.

can you guys please help me?

Thanks

 

[Jack Li]

Hi CZ,

I guess it should be month(now())?

Regards,
Jack Li
MVP (ASP.NET)