• Month of Date (Office 2000)

    Author
    Topic
    #361315

    I’m using Office 2000 on a PIII 600 MHz with 128 MB RAM on a Novell 5.0 network. I have a table of clients with one field as DOB (date of birth). I need to simple way in a query to find all the people born in October no matter what year.

    Viewing 0 reply threads
    Author
    Replies
    • #545872

      Try something like

      SELECT Name, DOB
      FROM [Names]
      WHERE Month([DOB])=10;

      Of course, your DOB field must be defined as a Date/Time data type for this to work.

    Viewing 0 reply threads
    Reply To: Month of Date (Office 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: