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...


  3. OP
    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. OP
    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. OP
    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#.
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page