Re: How to select between a range of dates?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: 04Ram (04Ram_at_discussions.microsoft.com)
Date: 11/01/04 

Date: Sun, 31 Oct 2004 20:46:02 -0800

MVP this really helped me out. I have one more question though. Until an
associate reaches 2 years their review is dependant on their hire date. For
example an associate was hired on 02/12/04. They have a 90 day review, a 9
month review, and a 18 month review. When they hit 2 years then their review
date is what I described before. How can I incorporate this into the query so
that I can only get those associates that have more than 2 years and another
one that retrieves those under 2 years. The problem is that those under 2
years would be year dependant. I am guessing that this would be 2 different
querries. Thanks.

"John Spencer (MVP)" wrote:

> Interesting problem. Because of the year wrap, the January Reviews would be
> based on
>
> WHERE Format(HireDate,"mmdd") BETWEEN "1116" and "1231" OR
> Format(HireDate,"mmdd") BETWEEN "0101" and "0215"
>
> The other 3 quarters would be simpler
>
> WHERE Format(HireDate,"mmdd") BETWEEN "0216" and "0515"
>
> WHERE Format(HireDate,"mmdd") BETWEEN "0516" and "0815"
>
> WHERE Format(HireDate,"mmdd") BETWEEN "0816" and "1115"
>
> I will have to ponder awhile on how to generalize this. Or hope someone else
> has already worked out a method.
>
>
> 04Ram wrote:
> >
> > I am trying to set up a query that finds hire date between a range of dates.
> > I know that I can use the between function to do this. It is irregardless of
> > year, just on the month and day. e.g. January reviews are from 11/16 to
> > 02/15. Is there a way to do this without using the year?
>

Relevant Pages

  • Re: Query look up
    ... I have a query that looks up testing being done. ... After I review the record ... You would base the Combo on a Query with a criterion selecting the ... John W. Vinson [MVP] ...
    (microsoft.public.access.gettingstarted)
  • Re: How to select between a range of dates?
    ... A 90 day, 9 month, or 18 month review is based strictly on their hire date. ... >> MVP this really helped me out. ... How can I incorporate this into the query so ... >> querries. ...
    (microsoft.public.access.queries)
  • Re: How to select between a range of dates?
    ... Need more details on how you decide someone is due a 90 day review or a 9 month ... > associate reaches 2 years their review is dependant on their hire date. ... Because of the year wrap, ... >> I will have to ponder awhile on how to generalize this. ...
    (microsoft.public.access.queries)
  • Re: Converting bad table design to good design
    ... There isn't really a whole lot to learn about append queries. ... query) they are queries like any other. ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... >>> Category for review ...
    (microsoft.public.access.externaldata)
  • Re: Turn off Reviewing in Word 2003
    ... To add to what Bob has said, you may want to read "Review Toolbar Annoyance" ... Word MVP FAQ site: http://word.mvps.org ... Changes feature & doesn't realize that she is broadcasting the doc's ...
    (microsoft.public.word.newusers)