Thread: Date
View Single Post
  #1  
Old June 4th, 2010, 06:52 PM posted to microsoft.public.access.gettingstarted
Sassy[_2_]
external usenet poster
 
Posts: 2
Default Date

I have a table with a start date column. I have created a query where I
include the start date from my table, I have created an expression to add 24
months to the start date but what I would like to also have is either the
specific date or the closest month of May.
for example Start date is July 1, 2008 if I add 24 months it will show July
1, 2010
What I would like to see is May 2010 as this the month that we identify
individuals that need to start a secondary process.

Very new to access and not that great with formulas
--
Thank You
Sassy