Post reply

T-SQL to get dates

  • 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

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply