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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.