I am not an expert in SQL, and I need to figure out the following:
- given a start date, output the 12 months date ranges until the date range that includes today
For instance, the start date is 10 June 2010, the date range I should produce would be
10 June 2010-10 June 2011
10 June 2011-10 June 2012
10 June 1012-10 June 2013
10 June 2013-10 June 2014 <--- this includes today's date of 1 July 2013.