• So, is this the simplest and quickest way to get the last day of any month?

    DATEADD(MONTH,x,'2010-Jan-01')

    Where x is the month you are looking for the last day.

    I've seen a lot of code over the years that performs some sort of find the first day of the month after the month in question, then subtract 1 day. Seems totally unnecessary with this function.