Calculate Evaluation dates (90 day and 1 year)

[jweber]

I have a field for the hire date, and I also have a form that SHOWS the evaluation dates, but there is not a field for them. I am currently trying to create a report where the Personnel Dept. can enter a month, and it will pull up any employe that is due for an eval (either 90 day or 1 year). I would like to do separate reports. I looked at some other date problems posted, but I do not understand how to accomplish this in a query.

Any help would be greatly appreciated! ( I would have searched more extensively, but the search operator is down!)

Thanks in advance!

 

[Darrylles]

Hi,

Please clarify what u mean by:

"SHOWS the evaluation dates, but there is not a field for them"

Kind regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[shannonp]

Not sure I fully understand this:

You have a field called [hire date]...where this is a set value for each person.

Is what you want to do is calculate evaluation dates from the date a person is hired [hire date], 90 days after they were hired AND 1 Year after they're hired?

If so, then the following might be helpful, otherwise could you explain it to me just one more time

[90d_Eval] = [hire date] + 90
[Yr_Eval] = [hire date] + 365

Hope this helps

 

[jweber]

Darrylle/Shannonp1:

On my form, I have an actual field for the hire date. On the same form I have done exactly what shannonp1 has suggested. Now, on the report I am trying to create, I need to set parameters so that the user can enter say, all the people that are up for a 90 day eval for January. (ie enter 1/1/2003 & 1/31/2003. Since my field for the eval dates is an expression, for some reason the query does not like the parameters and gives me everyone that had an eval due for January, regardless of year.

I hope this clarifies.

Thanks.

 

[shannonp]

So would your "parameter" (or criteria) look something like this then:

"Between #01/01/03# And #01/31/03#" (no quotes)

note: [90day_Eval] and [1Yr_Eval] should be assigned identical criteria, making sure to have them on seperate criteria lines in your query

also, "#01/01/03#" can be a link to a form value if you like (eg. Forms![MyForm]![Eval Date]) rather than explicitly assigning a dummy vairable statement (eg. "[Enter Evaluation Start Date]&quot. This way you won't have to hassle with the query field values being in the correct date format when entered by the user...simply put those formatting constraints on the form field directly.

 

[jweber]

What I ended up doing was designing a make table query, pulling out all of the hire dates from my employee table, and using expressions to calculate the 90 day and 1 year eval dates. I then created a different query to pull that new table's information to a report. Thanks for your help, though!