Help in understanding begin and end dates what they doing

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  June 15, 2016 at 2:41 pm

  #327174

  SET @EndDate = ( SELECT Max(d.End_Dt) FROM dbo.date d

  WHERE d.End_Dt < getdate() )

  SET @BeginDate = DATEADD(mm,-12,@EndDate)

• Jacob Wilkins

  One Orange Chip

  Points: 27976

  More actions

  June 15, 2016 at 2:51 pm

  #1885266

  There's a table of dates (presumably), dbo.date.

  The first SET command sets the @EndDate variable to be the most recent date from the dbo.date table that is earlier than the current datetime.

  The second SET command sets @BeginDate to 12 months before @EndDate.

  Cheers!