[AccessD] Six Month Review

Ed's on the money, I use something similar, it takes today's date and gets the exact 6 month prior:

RollingDate = Format(DateAdd("m", -6, Now), "mm/dd/yyyy")

>>> "Tesiny, Ed" <EdTesiny at oasas.state.ny.us> 2/1/2007 10:44 AM >>>
I think the DateAdd function would do it...DateAdd("m",6,[DateReview])

Ed Tesiny
EdTesiny at oasas.state.ny.us 
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Hollis, Virginia
> Sent: Thursday, February 01, 2007 10:28 AM
> To: accessD at databaseadvisors.com 
> Subject: [AccessD] Six Month Review
> 
> I need to determine the next semi-annual review date. So if the review
> date is 2/22/2007, the next review should be 8/22/2007. I have
> DateReview & DateNxtReview fields - how do I get the DateNxtReview to
> add 6 months to the DateReview field?
> 
>  
> 
> Virginia
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd 
> Website: http://www.databaseadvisors.com 
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com