Welcome to SPN

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

Sign Up Now!

Start Date within last 12 months

Discussion in 'Information Technology' started by Bruum, Jul 28, 2006.

  1. Bruum

    Bruum
    Expand Collapse
    Guest

    Hi there

    Can someone help with date query. I need to bring up only staff members
    with a start date within the last 12 months. This is then grouped into
    quarters to display winning Rookie of the quarter.

    Added complication is that if the staff member started in say August 2005,
    they would not qualify for the July-September quarter, as they would be over
    12 months in that period, so they would fall off the graph at the end of the
    March-June quarter.

    I have an existing query with the old criteria for "StartDate" being
    >#1/07/2005#.
     
  2. Loading...

    Similar Threads Forum Date
    Since When Did We Sikhs Start Getting Depressed, Anxious , OCD And A Host Of Other Mental Illnesses Health & Nutrition Apr 15, 2016
    Malaysia Sikhs Start Free Clinic In Kuala Lumpur Breaking News Mar 10, 2015
    SciTech B-School Startup: Turning Coffee Grounds Into Food Breaking News Sep 2, 2013
    Arts/Society Entrepreneurship Program Gives Trafficked Women a Fresh Start Language, Arts & Culture Sep 2, 2013
    India Sikhs themselves should first start maintaining dignity of turban Breaking News Aug 8, 2013

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Try StartDate > DateAdd("yyyy", -1, Date())

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Bruum" <Bruum@discussions.microsoft.com> wrote in message
    news:71F66BB2-0AD1-49B6-B827-EF10F0AA181B@microsoft.com...
    > Hi there
    >
    > Can someone help with date query. I need to bring up only staff members
    > with a start date within the last 12 months. This is then grouped into
    > quarters to display winning Rookie of the quarter.
    >
    > Added complication is that if the staff member started in say August 2005,
    > they would not qualify for the July-September quarter, as they would be
    > over
    > 12 months in that period, so they would fall off the graph at the end of
    > the
    > March-June quarter.
    >
    > I have an existing query with the old criteria for "StartDate" being
    >>#1/07/2005#.

    >
     
  4. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Try

    Where [start date] Between DateAdd("m",-12,Date()) And Date()

    --
    Good Luck
    BS"D


    "Bruum" wrote:

    > Hi there
    >
    > Can someone help with date query. I need to bring up only staff members
    > with a start date within the last 12 months. This is then grouped into
    > quarters to display winning Rookie of the quarter.
    >
    > Added complication is that if the staff member started in say August 2005,
    > they would not qualify for the July-September quarter, as they would be over
    > 12 months in that period, so they would fall off the graph at the end of the
    > March-June quarter.
    >
    > I have an existing query with the old criteria for "StartDate" being
    > >#1/07/2005#.
     
  5. Bruum

    Bruum
    Expand Collapse
    Guest

    Thank you Ofer and Douglas for your very prompt reply. Both worked fine, and
    can now sleep at night :)

    "Ofer Cohen" wrote:

    > Try
    >
    > Where [start date] Between DateAdd("m",-12,Date()) And Date()
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Bruum" wrote:
    >
    > > Hi there
    > >
    > > Can someone help with date query. I need to bring up only staff members
    > > with a start date within the last 12 months. This is then grouped into
    > > quarters to display winning Rookie of the quarter.
    > >
    > > Added complication is that if the staff member started in say August 2005,
    > > they would not qualify for the July-September quarter, as they would be over
    > > 12 months in that period, so they would fall off the graph at the end of the
    > > March-June quarter.
    > >
    > > I have an existing query with the old criteria for "StartDate" being
    > > >#1/07/2005#.
     

Share This Page