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
 
Back
Top