Regarding a date function in MS Access 2007 query

Hello everybody,
I am using a MS Access query to generate a report of employee data. I have one field called "RecruitDate", and another field call "evaluation date". "Recruitdate" field is already filled in. I want the field "evaluation date" automatically by calculating "Recruit Date" + 1 Month.

In other words, evaluation-date should be exactly after one month of recruit-date.
Can anybody please guide me with the formula to put in MS Access query.

Any kind of help will be appreciated.
Thanx in advance
John_BASAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:


select *, dateadd("m",1,[RecruitDate]) as [evaluation date]  from table
0
 
Rey Obrero (Capricorn1)Commented:
if you want to update the field [evaluation date], run an update query

update table
set [evaluation date]=dateadd("m",1,[recruitdate])
where [recruitdate]<> null
0
 
John_BASAuthor Commented:
Thanx a lot capricorn.
I am going to try it.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Dale FyeCommented:
Assuming that your employees require occassional evaluations, and that you are concerned with these evaluations, you might want to consider modifying your database structure to include a table for storing employee evaluation data (Employee_ID,Eval_Date, Evaluator_ID, Reviewer_ID, ...).  This way, you have a separate table where you store information specific to the evaluations received by that employee.

In that case, you would want to insert a record into this table rather than just updating an [evaluation date] field in your employee table.
0
 
John_BASAuthor Commented:
Hello capricorn1,
Thanx it is working perfectly. I have one related request. Should I ask it in a separate question.

It is that I want to format the date to show up as complete date: 4 april 2011. Can you please also give me a tip over it?
0
 
Rey Obrero (Capricorn1)Commented:
just do a formatting

format([datefield], "dd mmmm yyyy")
0
 
John_BASAuthor Commented:
Thanx a lot Capricorn1.
0
 
John_BASAuthor Commented:
The solution was perfect!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.