Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Criteria for only certain months of a birthdate

Discussion in 'Information Technology' started by Cris, Nov 3, 2005.

  1. Cris

    Cris
    Expand Collapse
    Guest

    How do I retrieve only birthdates in the months of May, Jun, July in a query?
    I have a DOB field that is date formatted and need to pull up only
    birthdates in those 3 months. What do I set the criteria to? Thanks ahead
    of time for any help.
     
  2. Loading...

    Similar Threads Forum Date
    Criteria: When She Deserves to be Raped Hard Talk Dec 21, 2012
    Sikh News Punjab mulling change in pass criteria in board exams (Outlook India) Breaking News Dec 3, 2007
    World Afghanistan's Sikhs face an uncertain future Breaking News Feb 28, 2014
    Who, what makes sadh babas ?? Certainly NOT Guru Ji ! Hard Talk Aug 31, 2013
    World Bhutto's son's role in pakistan election uncertain Breaking News Mar 27, 2013

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    Use the month i a query.

    Select * From TableName Where Month(FieldName) In (5,6,7)

    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benefit from it.

    Good luck



    "Cris" wrote:

    > How do I retrieve only birthdates in the months of May, Jun, July in a query?
    > I have a DOB field that is date formatted and need to pull up only
    > birthdates in those 3 months. What do I set the criteria to? Thanks ahead
    > of time for any help.
     

Share This Page