Need date to change at start of a new year.

[KayJen]

I have a database to track employee evaluations on a year to year basis. The month and day are always the same, however, the year changes, or should hence this is where the problem lies. For instance in December 2003, I would like to send out a letter to all supervisors stating what evaluations are due, however, I can't because the year has not changed.

I have a database titled tbl_Personnel with a field labelled
Evaluations. I also have an unbound text box labelled Eval with the following: =DateAdd("yyyy",1,[Eval]), this part works except when the year 2005 and so on arrive. I there anyway to change the year portion even if its in the form of an unbound text box.

Thanks in Advance
Sonny

 

[jimb0ne]

I'm not exactly sure what you mean. Do you mean you want to change the Year field in a table you have, even though the textbox is unbound? if so this is reasonably simple. Let me know if I'm on the right track here.

 

[KayJen]

The field is a Date/Time field. When there is a new hire their date of hire is entered into the Date Field. A year from that date an evaluation is due, we are a 24hr., 7 days a week police department, so weekends and holidays do not matter. I want to build a report, so that in the last week in January, etc., I can get a printout of all Evals due in February, etc. The month and day need to remain the same, only the year from 2003 to 2004 need to change. I tried to figure out how to update just the year and failed, I tried an unbound text box and got it to change from 2003 to 2004, but when 2005 rolls around it will still show 2004. I'm just trying to eliminate some typing for the data entry clerk, so any solution is a welcomed solution.

Thanks,
Sonny

 

[jimb0ne]

I still don't fully understand the problem. What do you mean you need the date to change from 2003 to 2004? the date that is entered needs to change to 2004? or all the records that you have in your table already need to change to 2004? meaning, all the employees that are flagged for an evaluation need to have their eval dates moved ahead a year once notice has been given that they need to be evaluated? maybe you could send me your code if its access 2000 or before, zip it up and send it to jtseleie@theedge.ca

 

[jbento]

I did something similar.

Check this thread out: thread702-712178

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[KayJen]

Jerome tried yours, got the year but not the month and day. jimbOne, I enter this date into the field. 01/12/03, now we are in January 2004 I would like the year to now reflect 04, so it would now read 01/12/04. I'm just trying to prevent from having to enter the new year for 30 or more records per month.

01/12/03 needs to equal 01/12/04
01/22/03 needs to equal 01/22/03
and so on, for all the following months.

I'm even playing with an Update query, yet no positive results.

Thanks for your time,
Sonny

 

[jbento]

Here is a page that has a lot of access examples:

http://www.rogersaccesslibrary.com/TableOfContents2k.asp

In particular you should look at this access example:

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='DateStuff2k.mdb'

Let me know if this helps you out.

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[KayJen]

Thanks will give it a try.

Sonny