Compare access db birthday date field with date

Discussion in 'ASP .Net' started by CZ, Sep 22, 2005.

  1. CZ

    CZ Guest

    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
     
    CZ, Sep 22, 2005
    #1
    1. Advertising

  2. CZ

    Jack Li Guest

    Hi CZ,

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

    Regards,
    Jack Li
    MVP (ASP.NET)

    "CZ" <> wrote in message
    news:...
    > 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, Sep 23, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dmoniac75
    Replies:
    0
    Views:
    1,226
    dmoniac75
    Mar 4, 2005
  2. Travis Newbury

    Happy birthday Travis!

    Travis Newbury, May 27, 2005, in forum: HTML
    Replies:
    1
    Views:
    419
  3. Sandra

    Birthday Problem

    Sandra, Apr 12, 2004, in forum: C++
    Replies:
    58
    Views:
    4,050
    Bruce Clement
    Apr 14, 2004
  4. Chris Stephens
    Replies:
    0
    Views:
    235
    Chris Stephens
    Mar 31, 2006
  5. Michael Haas

    compare date field to current date

    Michael Haas, Feb 15, 2004, in forum: ASP General
    Replies:
    4
    Views:
    287
    Mike Haas
    Feb 15, 2004
Loading...

Share This Page