Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397

    Unanswered: Query Criterica For Specific Data...

    Hi,

    My table T_DOB has data field to along with other field. Let us say as follows

    Name Date_Of_Birth
    A 15/04/1966
    B 01/09/1975
    C 18/12/1963
    D 25/09/2000

    I created a query to get the data only for the month 09. It is as follows:

    Select T_DOB.Name, T_DOB.Date_Of_Birth
    From T_DOB
    Where T_DOB.Date_Of_Birth= DatePart(...?;

    This should give me only 2 records as follows:

    Name Date_Of_Birth
    B 01/09/1975
    D 25/09/2000

    How could I do this? Using Datepart function or any other function?

    Thanks in advace.

    Ashfaque

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Where month(T_DOB.Date_Of_Birth)=9

    Regards

  3. #3
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397
    Thanks.

    Ashfaque

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •