I think you can't get it with one line code or single function call.
You must write a function for this or you can construct an array include every month's last day. But in both two ways you must consider leap years also.
May be it is easier to find the next month's first day then step back 1 day by using dateadd function.




Reply With Quote