Converting dates to current dates to find out the evaluation 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.
 
J

John Spencer

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
Query Parameters 1
Can I use an IIF statement with the NZ function? 2
Converting Julian Dates to ##/##/## Format 3
selecting the most recent date 1
Excel Forecasting Dates Out to the Day 3
Current Week 2
query exactly a year from now 14

Top