vickymae222 (5/17/2009)
This is the expression I have been looking for. I have a field called Plan End Date that I need to calculate the end of the month that the Plan End Date is in. How do I write this expression? thank you!
Select
dateadd(mm,datediff(mm,-1,PlanEndDate),-1) as PlanEndOfMonthDate
from
MyTable