Last day of the month from calculated column
I am trying to get a computed column setup in an MSSQL database which will move 6 months into the future from the date in another column and tell me what the last day of that month is.
This is to calculate a due date which is 6 months in the future from whatever date, rounded to the end of the month.
My current compute statement moves 6 months in the future, is it possible to have it also grab the last day of the month it lands in?
(dateadd(month,(6),[YEAREND_DATE]))
Posted Oct 3, 2014, 6:04 PM UTC
Pinal Dave wrote a blog post on this.