Calculation of Date

[jlwst43]

I am trying to calculate Previous Avg TAT where the rec_date is between DateAdd("m",-6,now()) and dateADD("M",-3,now()). Also I am doing current AVG TAT which rec_Date is between DateAdd("m",-3,now()) and now(). When I put the two dates together, I receive example 8/28/00 - 12/28/00 for previous and current is 12/28/00 - 2/28/01. The previous date needs to be 8/29/00 - 12/28/00 and the current date needs to be 12/29/00 - 2/28/01. I know that I need to add a day but I am clueless on how to do this...any feedback is greatly appreciated.

Thanks