Converting dates to current dates to find out the evaluation date

  • Thread starter Thread starter Donica24
  • Start date Start date
D

Donica24

Hi,
I am trying to take the date of hire for a list of employees. For emample,
I need the hire date of 3/3/1990 to populate the 6 mos eval due this year and
the yearly due this year. I was able to figure out the dates by adding the
values of 182 and 365, but the year stays the same.
 
Perhaps using the DateSerial function will give you the desired results.


DateSerial(Year(Date()),Month([HireDate]),Day([HireDate])) as Annual

AND

DateSerial(Year(Date()),Month([HireDate])+6,Day([HireDate])) as 6Month

Those should return 3/3/2010 and 9/3/2010
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Date value to current year 3
calculate two dates 1
Make query to calculate two dates 2
Years of Employment 2
Date differential between a full date and a date that has a year and month. 5
Can I use an IIF statement with the NZ function? 2
selecting the most recent date 1
Current Date in Query 12

Back
Top