«

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

Hi CZ,

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

Regards,
Jack Li
MVP (ASP.NET)

"CZ" <> wrote in message
news: ps.com...
> 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
>