[AccessD] Six Month Review

My personal preference is the DateSerial function:

DateNxtReview=DateSerial(Month(DateReview)+6,Year(DateReview),
Day(DateReview))

Drew

-----Original Message-----
From: Hollis, Virginia [mailto:hollisvj at pgdp.usec.com] 
Sent: Thursday, February 01, 2007 9: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