Hello Experts Exchange
I have a SQL Server 2012 table with a finance period in it. Please see attached Excel for example data.
I need SQL Script that gives me the first and last date of the pervious period.
So for example the pervious period for today is period 8 and the first date is 02/08/2015 and the last date is 29/08/2015.
How do I get these dates using SQL.