T-SQL to get dates

• SSRS Newbie

  Hall of Fame

  Points: 3244

  More actions

  March 16, 2015 at 2:22 pm

  #305769

  I've SSRS sales report to which I need to pass the dates for previous month's start date and end date which I am able to pass using below code. However, since the sales report has data from the past year(2014) I need to pass the dates for last year as well. The below code gives StartDate1 as 2015-02-01 and EndDate1 as 2015-02-28. I need to get the dates for past year like 2014-02-01 as StartDate2 and 2014-02-28 as EndDate2

  SELECT DATEADD(MONTH, DATEDIFF(MONTH, '19000201', GETDATE()), '19000101') AS StartDate1,

  DATEADD(MONTH, DATEDIFF(MONTH, '19000101', GETDATE()), '18991231') AS EndDate1

• ZZartin

  SSC-Dedicated

  Points: 30894

  More actions

  March 16, 2015 at 2:27 pm

  #1784353

  SELECT DATEADD(year, -1, DATEADD(MONTH, DATEDIFF(MONTH, '19000201', GETDATE()), '19000101')) AS StartDate1,

  DATEADD(year, -1, DATEADD(MONTH, DATEDIFF(MONTH, '19000101', GETDATE()), '18991231')) AS EndDate1