Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Working with dates

    I need to look at a hire date and decide when a person's yearly evaluation will be. The person must have 6 months of service before November 1 to receive a yearly evaluation in the same year. If not, it falls in November of the next year. Example is: If hired between Nov. 1,(Previous year) and April 30,(Current Year) the evaluation would be in November of Current year, but if hired between May 1,(Current year) and October 31, (current year) evaluation is not until November of (next year). I want to set up a query to tell me when the evaluation is due after hiring and each year thereafter. Please help.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working with dates

    Use a query like this:

    SELECT tblTest.ID, tblTest.fldDate
    FROM tblTest
    WHERE (((DateDiff("y",CDate(#11/1/00#),[tblTest]![fldDate]))<-184));

    Bart
    Software Designer

Posting Permissions

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