[AccessD] Six Month Review

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
>