SQL - First Month of Year and Last day of previous month.
Posted on 2013-08-27
I have a need to pull the first month of current year and then also pull the previous month end.
1/1/2013 - 7/31/2013
I'm doing a parameter with a report and need to have this date automatically populated. I am able to get the end of month for last month. However, I can't seem to get the first month for the year at beginning of month.